Discussion board where members can get started with Qlik Sense.
Is this structure possible in qliksense?
Actual, Forecast, Budget vs Forecast and Actual vs Forecast are different expression.
there is different expression for each cell.
The answer is yes.
You can achieve this either by making addition and modifications to your data model or you can make use of ValueList() to create synthetic and calculated dimensions.
Yes we can do it in Qlik Sense.
You need to create 2 dimension for the header, and use Pick,Match for the measure.
For detail please have a look at attached app. !
May be, Try with the below links, change the expressions as per these.
And play around with Rows, Columns in Pivot table.
I achieved it but now can I remove search box from pivot table
Please assist me on this.
Thank you in advance.