I need double header in pivot table which looks like below image please any one help in this issue

[chinnu123]

Hi community

See below image,
2nd column i.e May fall under CURRENT field
Overall, April and Monthly% fall under YTD actuals,
and May, April and Trend% fall under Soverign Actuals.

Please help

  Thanks in advance..

[sinanozdemir]

Hi,

You can use ValueList() in your dimension and in the expression Pick(ValueList(value1, value2), expression1, expression2)

Hope this helps.

[chinnu123]

Thanks for your reply Sinan.

  But its not working in my case

[qlikviewwizard]

Hi Chinnu,

Please attach the sample file.