Discussion Board for collaboration on QlikView Scripting.
Hi, I want to count how many of each PO Num exists so I did this simple straight table:
I did another straight table and added in the other variables:
May I know how to get this:
I've already tried formulas such as Count(PO_Num), textcount(PO_Num) and aggr(Count(PO_Num),PO_Num,Store,Date) but I still got 25 as the total count.
Try like this
For Table1 :
=Max(Aggr(Count(PO_Num), Date, PO_Num, Store, [Line Cost], [Unit Cost]))
For Table 2:
Hope this helps you.
Thanks, but if I use count(distinct the result will only be 1 record for that PO_Num, but it's supposed to be 5 records
For this use : =Max(Aggr(Count(PO_Num), Date, PO_Num, Store, [Line Cost], [Unit Cost]))
For this : Count(DISTINCT PO_Num) - Using distinct you will get 1, I think this is what you are expecting.
Thanks, but actually I only want this table:
This larger table is only for me to check why the count of PO_Num is 25 instead of 5:
I still don't get my desired table using ' =Max(Aggr(Count(PO_Num), Date, PO_Num, Store, [Line Cost], [Unit Cost]))'.
Is there any chance you might know why each record for PO_Num '1234' is duplicated 5 times? Because now I am getting this table:
And to see why there are 25 records for PO_Num '1234', I did this next table:
You have different line costs that is the PO_Num count is duplicating.