topic Label in Pivot Table in QlikView

Label in Pivot Table

Anonymous — Thu, 29 Oct 2015 03:00:52 GMT

Hi all,

I want to build a pivot table like this

The label for each expression is the Year and the Dimension Value (Red circle)

However, it doesn't work as what I expected, it only shows the Year, it cannot get the Dimension value

Is there any function I can get the Value of the Dimension and put it in the label?

Attached the QVW for reference.

Many Thanks!!!!

Paddy

jagan — Thu, 29 Oct 2015 03:06:58 GMT

Hi,

Can you attach some sample file? You want to replace Header 3 or Header4 with Department A- Team1 and Department B- Team2?

Regards,

Jagan.

sujeetsingh — Thu, 29 Oct 2015 03:12:13 GMT

Come in more words and better with sample .

HirisH_V7 — Thu, 29 Oct 2015 04:01:17 GMT

Hi paddy ,

Jus remove the dimension team . You will have single Header "Team and Department" is this you require or can you explain more .

Regards,

hirish