Qliksense pivot table Create column based on measures
we want to create column based on measures, for sample as below, could you help to share some ideas? Thanks in advance.
For below screenshot what we can achive in Qliksense now, we want to create column, for column C(Budget) and D(Consumption) we create column'A' for them, for E(Scan),F(Second_scan) and G(Retailer_Scan), we create column 'B', for H(Budget%),I(Second_Scan%) and J(Retailer%) we create column 'C'.
Below screenshow was what we want to achive,
Is it possible for this setting in visualization level? Thanks.
The only solution might be make the pivot and pre-calculated value for the measures in dataload like what I did in above illustration. I'll not the perfect solution, because fitlters on GUI will not be updated but reload.
No idea why pivot table don't hide the null columns, hmmm