Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
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.
Regards,
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.
https://community.qlik.com/thread/128166
https://community.qlikview.com/message/38436#38436
And play around with Rows, Columns in Pivot table.
Hi,
I achieved it but now can I remove search box from pivot table
Please assist me on this.
Thank you in advance.
Regards,