Discussion Board for collaboration on QlikView Scripting.
Please help me for creating the new table from the 2 or 3 tables for the Calculation in the Pivot table.
I want to Sum the Score Area wise in the pivot table
New table in script
(ooxml, embedded labels, table is Table1);
(ooxml, embedded labels, table is Table2);
if (Quantity - [TargetQuantity] >= 0.8, 1, 0) as Score,
Drop Tables Table1,Table2,TempTable;
This script is not working the result is synthetic key error accouters.
can any one help me to solve this issue.
I'm not sure I totally understand your problem. Could you explain more?
Why can you not do this in the pivot table expression rather than building a new table in the script?
I have tried in the pivot table but i am not getting what i want.
I want to total numer of customer who achievement is more than 80% in a particular Area
Without joining the two tables, in the pivot table you just need an expression like:
if (sum(Quantity) - [TargetQuantity] >= 0.8, 1, 0)
Depending if Quantity and TargetQuantity are unique values or not (depending on month...) you will need to change the expressión ( sum(TargetQuantity) instead of just TargetQuantity )
Hope that helps
Ok, I would still try to do this in the front end, otherwise you are limited by your dimensions that you have pre-calculated across.
What was your expression in the pivot and do you know why it did not work?
It would use a combination of count and aggr...
I have tried this expression it is still not working
Could you please share the script where you load table1 and table2? And a sample of the information stored on those tables would be useful too.