Discussion Board for collaboration on QlikView Scripting.
Can someone help me in getting the count() function executed
Place, Building, Location, Units, Bridge, Barcode, Units, Bay, Position, Level, Position&Level as PL, Bay&Location as BL
I wanna get the Count(Barcode) by Place
Count(Barcode) by BL
Count(If(Units>0, Barcode) by Place
Count(If(Units>0, Barcode) by BL
Sum(Units) by Barcode;
Go to Solution.
Yes, your code will work, Instead the below code will also give the same result.
Count(Distinct(LBCD)) as tt,
Sum(Units) as TOtalUnits Resident Table1 Group By Warehouse,LBCD;
Why does it need to be done in the load script and not in the App itself? Just to get a better understanding of what you would like to accomplish.
There millions of rows of data which is slowing down the app when its calcualted in front end.
Could you post small sample of your data?
Please find the attachment.
sunindia Can u too have a look at this!
I'm using PE.
Attached csv or xls
Was trying this Sir.
(ooxml, embedded labels, table is Sheet1);
Load Count(LBCD) as Total, Count(If(Units>0, LBCD)) as Filled Resident Table1 Group by Warehouse;
Load Sum(Units) as TOtalUnits Resident Table1 Group by LBCD;
This is the same data set as per your first post....?
I created a sample data sir.