Discussion board where members can learn more about Qlik Sense App Development and Usage.
If (Client_type=Individual and country = 'A', (Sum(VALUES)-(value))/sum(VALUES),
If (Client_type=Individual and country = 'B', (Sum(VALUES)-(value))/sum(VALUES),
I used above formula in pivot table but I am getting negative values in % column, that is not correct. somebody help me to fix that issue ..I want to fix this issue in the next 48 hours.
Awiting Solution on this error..
Thanks in advance for quick response
Would you be able to share a sample to visualize your issue?
Yes..I am using excel data
That is great, would you be able to share the Excel and if possible also share the expected output?
I have used IF OR condition but I am getting only % of country and other country showing wrong calculation.
do you want sample data excelsheet
Something to make sense of your question....
where is option for attached?
Uploading a Sample
Please find the attached excel sheet. Sheet A and B containing month wise dataTotal_a and Total_b containg total count of data..This is sample template of random data.
Formula for calculation is using as
(Total Value - Value for DE) / Total Value
I have attached the data..
I am using below script
LOAD DE, "FCC 20", CATEEGORY, "DQ DIM", Country,
FROM [lib://HK/HK_Sales_1.xlsx](ooxml, embedded labels, table is Sheet1);
(ooxml, embedded labels, table is a);
crosstable(Month,Values,1) -------------- Change the name as BValues instead of Values
I am using three tables currently. But visualization part not giving correct result for calculation in the pivot table.
by using If condition:
Note: I have change the name of Values in the 2nd table as BValues