Create Table Data for Dashboard by QlikView - 1

How to use QlikView in the first time to create simple dashboard?

HELLO!
How are you? How is your life there? How is the weather? in Thailand it's very so hot, that can melt me, however I hope you enjoin life for this summer time.

For this season I would present you how to create table data on dashboard by QlikView (If you do not know about QlikView you can click on this link http://www.mymemoboxs.com/2015/04/what-is-qlikview-product.html)

And for good news, I have recorded VDO how to for all of you too, but for the sound that so sorry, You have to imagine how is your voice look like ^__^

OKEY! Enjoin VDO
https://youtu.be/4JQ9q9oQy2M

Read More

SQL Server Create Table

How to create table in SQL Server that very simple for the beginner.

Note!
Please do not create the same  name of Table in View Module of SQL Server Database

CREATE TABLE [dbo].[DATABASE_TABLE1](
[T_YEAR] [varchar](50) NULL,
[T_MONTH] [varchar](50) NULL,
[T_ACCOUNT] [varchar](50) NULL,
[T_NAME] [varchar](50) NULL,
[T_LASTNAME] [varchar](50) NULL,
[T_SALARY] [decimal](18, 2) NULL
) ON [PRIMARY]

Create command as details as above then click on "Execute"
or You can follow methods as image below

STEP-1Create command to create table





STEP-2After click on "Execute" then click right on database for refresh, you will see the table have created




STEP-3Click right at table then select design menu



STEP-4
You will see the structure of table as image below



STEP-5
Set Primary Key by click right on that field

Primary Key have created

Read More

SQL Select change column to row

How to change column from table to row?

Example data from table1

id	name	lastname	month1	month2	month3
1	name1	lastname1	300	400	500
2	name2	lastname2	10	20	30

Code :

SELECT id,name,lastname,amount,month
FROM (
SELECT id,name,lastname, month1 as amount, '1' as month FROM table1 as t1
UNION ALL
SELECT id,name,lastname,month2 as amount, '2' as month FROM table1 as t2
UNION ALL
SELECT id,name,lastname,month3 as amount, '3' as month FROM table1 as t3
)

Result :

id	name	lastname	amount	month
1	name1	lastname1	300	1
1	name1	lastname1	400	2
1	name1	lastname1	500	3
2	name2	lastname2	10	1
2	name2	lastname2	20	2
2	name2	lastname2	30	3

Read More

What is QlikView Product?

What is QlikView? Is it good for Business Intelligence?

I fail in love with QlikView immediately after I have tried to used it for the first time, If you are a developer of BI tools, You may know or do not know about this product, but let's me tell you some thing how is QlikView cool?

WHAT IS IT?
QlinkView is the one product (from Sweden) to create Business Intelligent concept to generate report, the dimension of report that you want to see and process, in basically of general report you will see only 2 dimension of data but if you use BI concept, you can answer and question of your boss when he/her would like to know some information of data in different view in 2 minutes.

HOW IS GOOD in QlikView ?
- Very simple and easy to create report
- Support every database type by use connecting driver
- Fast and Smooth
- Write in memory concept that why it make QlikView process report very fast
- You can create What's if as you want
- Available import google map to create bubble

You can download and use it by link before, it's free and can use any feature like license product but the different thing is you can not run report in any other computer, except the computer you have installed QlinkView
http://www.qlik.com/

Read More

Jquery DatePicker Show Full Month Name and Year

Result




Jquery Code


$("#dateStart").datepicker({

changeMonth: true,
changeYear: true,
showButtonPanel: true,
dateFormat: 'MM yy',
onClose: function(dateText, inst)
{
    var month = $("#ui-datepicker-div .ui-datepicker-month :selected").val();
    var year = $("#ui-datepicker-div .ui-datepicker-year :selected").val();
    $(this).datepicker('setDate', new Date(year, month, 1));
}

});

Read More

Godaddy I am angry you! T_T

WHAT HAPPEN WITH GODADDY?

Somebody can help me? please I spent almost one week to fixed the problem how to connect the database.

Let's me tell you about bad mood with godaddy.com, Yes I am the one customer of them for many years ago, I loved godaddy features, They have many features for you to selection to matching with your business and needs, It was very simple and easy to config.

I buy many domain name from godaddy and I also paid for hosting because it was stable and simple for me to config but now every things seem harder then before.

1. I do not understand why godaddy not set www to be default to transfer files ( After I transfer files to godaddy I could not laugh my website immediately)

2. After I created database and connected to database by use PHP script, until now I still do not know what is wrong? The script said I could connect to server but database could not, I have checked username, password, database name, every things look find but T_T why I still cannot connect to my database.

This is a very simple script to connect database

$hostname = "localhost";

$username = "username";

$password = "password";

$dbname = "databasename";

mysql_connect($hostname,$username, $password) or die("Can not connect to server");

mysql_select_db($dbname);

mysql_query("SELECT * FROM mytable");

BUT you do not allow me to get in WHY? I'm sad

3.Godaddy help support is not convenient, They put all solutions in blog and the customer have to search there but some of my problem were different from them and I have to spent a lot of time to searching, They have only calling number, before I just open my problem and they solved the problem for me very fast but now so different.

4.I'm not happy for godaddy help center, it was not help and one more thing I just wonder why godaddy seem slow more then before, I spent a half of day to transfer my files (only 22.MB) to server Or it because I living far away from you? Yes you live in USA for me I live in Thailand or this is the reason why you do not care about me? T_T

5.And for user interface to set up, it seem too slow when I click on some link and page, I had count how much time it take 1 2 3 4 5 6 7 8 9....20 some page almost to 30 OH! my god, I would like to change to use an other hosting.

6.Any one have bad experience like me with godaddy?

SORRY to talk about you godaddy but seem like you have developing in wrong way...the way you were before was nice that why I return to use your products.

I hope you will help me and improve your products, This is the way I can connect you because you close every way for customer to contract you in direct.

Read More

Reporting Service Configuration to Sending Mail

The photo is not match about the story I will talking about today, I knew that but I just want all of you to be happy and smile ^_^ and I likes her hips even I am a girl and straight.

OKEY! today I would like present how to configuration mail on SQL Reporting Service to sending mail to any concerns.

STEP-1
Go to "SQL Server Reporting Service Configuration Manager"

STEP-2
You will the popup as image below, This details in window it for configuration of SQL Reporting Service Only

STEP-3Then you have to fill mail server detail as image below

Read More