Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Team,
I have some requirement in Pivot in qik sense, i receive data client in excel.
Here we see total Sales is 1260 , so i need to put total sales value 1260 for England country. How to Achieve this in qlik sense any frontend or backend also.
source:
Countrty | Group | Sales |
India | A | 100 |
Austrilia | A | 150 |
England | A | 200 |
Canada | A | 230 |
India | B | 100 |
Austrilia | B | 160 |
England | B | 170 |
Canada | B | 150 |
out put qlik sense in pivot:
Sum of Sales | Group | ||||||
Countrty | A | B | (blank) | Grand Total | A | B | Total |
Austrilia | 150 | 160 | 310 | ||||
Canada | 230 | 150 | 380 | ||||
England | 200 | 170 | 370 | 1260 | 1260 | ||
India | 100 | 100 | 200 | ||||
Total | 1260 | 1260 | |||||
Grand Total | 680 | 580 | 1260 | 2520 |
Hi, Maybe with: If(Country='England', Sum(TOTAL Sales))