Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

big_dreams
Contributor III

create multiheader pivot in qliksense

Hi all,

Is this structure possible in qliksense?

Capture.PNG

Actual, Forecast, Budget vs Forecast and Actual vs Forecast are different expression.

there is different expression for each cell.

Regards,

4 Replies
MVP
MVP

Re: create multiheader pivot in qliksense

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.

Quy_Nguyen
Contributor III

Re: create multiheader pivot in qliksense

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. !

balabhaskarqlik
Honored Contributor

Re: create multiheader pivot in qliksense

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.

big_dreams
Contributor III

Re: create multiheader pivot in qliksense

Hi,

I achieved it but now can I remove search box from pivot tablesearch_box.PNG

Please assist me on this.

Thank you in advance.

Regards,

Community Browser