LOAD No, Customerid, Count(Customerid) as Count,
I would like to Count Number of customer while lodaing using scrip. Please help me.
Try as below
No, Customerid, Count(Customerid) as Count,
Group By No, Customerid;
Count(Customerid) as Count
Group By Customerid;
I tried the above code but getting the following error. I am using trail version is that the case?
Group By No, Customerid, all other fields also except Count(Customerid);
You need to add all fields in Group By
Hi try Below
Drop table Temp;
count(CustomerID) as Count
group by No, CostumerID
just in case you have some other fields you want to load you also have to put it in the group by statement.
I am trying to write code to create a list box with Product Name and count of number of Customerids like the graph below. The purpose is to create custom list boxes using the Script and visualize them. Can I write SQL scripts in Qlikview.??????
Retrieving data ...