Discussion Board for collaboration on QlikView Layout & Visualizations.
I have this requirement of including header on top of pivot or straight table. Is it possible to include a header in the format shown above in qlikview
Go to Solution.
if you don't have the dimension for daily sales and monthly sales, create calculated dimension like
=valuelist ('daily sales','monthly sales')
In the expression
=pick (match (valuelist ('daily sales','monthly sales'),
'daily sales','monthly sales'),daily sales expression 1,monthly sales expression1)
Like above you need to do 5 time(separate expression).
This gives idea.
Thanks it worked !