topic Re: Change the header based on the type in QlikView

Change the header based on the type

Mon, 17 Dec 2012 15:33:14 GMT

I have a table like this

Toy Code, Description, Type

1,aaaaaaa,infant

2,ggggggg,infant

3,fgfggggg,toddler

4,sfgfdgfgg,toddler,

5,gdfgddfgg,infant

I want to show a table like this

Infant:

1 aaaaaaa

2 ggggggg

5 gdfgddfgg

Toddler:

3 fgfggggg

4 sfgfdgfgg

I am trying to achieve the above with a table box but unable to put the different headers. Can some one please help?

Thanks,

Re: Change the header based on the type

Miguel_Angel_Baeyens — Mon, 17 Dec 2012 15:53:31 GMT

Hi,

Table boxes are intended to show information, not to format or do any kind of transformation. Instead, use a Chart > Straight table or Pivot table and use those fields as dimensions.

Hope that helps.

Miguel

Re: Change the header based on the type

Mon, 17 Dec 2012 15:54:58 GMT

I tried that approach, but the Straight table and Pivot table are expecting expression which I don't have any in this scenario.

Re: Change the header based on the type

Gysbert_Wassenaar — Mon, 17 Dec 2012 16:00:53 GMT

Check the options Show All Values and Suppress When Value is Null. You won't need an expression then.

Re: Change the header based on the type

Mon, 17 Dec 2012 16:09:29 GMT

Thanks for your response. This worked. But I still having difficulty putting Type as the Header. I have defined all the three columns as Dimensions in the Pivot table. How can I make the Type field to show as header as follows.

Infant:

1 aaaaaaa

2 ggggggg

5 gdfgddfgg

Toddler:

3 fgfggggg

4 sfgfdgfgg

Re: Change the header based on the type

Miguel_Angel_Baeyens — Mon, 17 Dec 2012 16:10:45 GMT

Yes,

Or use 1 as expression then hide it, that will do as well. Or use "Toy Code" and "Description" as dimensions and "Type" (the field name) as expression that will also work.

Hope that helps.

Miguel