topic two fields in one dimension in QlikView

two fields in one dimension

Tue, 08 Jul 2014 15:34:00 GMT

Hello!

i would appreciate your help in this matter.

Like in the picture i can have two fields in one dimension in a pivot table. how can i do this?

Re: two fields in one dimension

Gysbert_Wassenaar — Tue, 08 Jul 2014 15:37:09 GMT

You can't. The best you can do is add both dimensions to the pivot table and enable the Indent option on the Style tab. Then on the Presentation tab choose Subtotals on Top and left align the dimension cell values.

Re: two fields in one dimension

lvf — Tue, 08 Jul 2014 15:40:53 GMT

In the Dimension tab of your Pivot Table, use a Calculated Dimension and concatenate two dimension values together

e.g.

You could also do this in the Load Script if you want you use more than once.

Re: two fields in one dimension

Tue, 08 Jul 2014 16:01:33 GMT

thank you Leona,

but then i will have something like this in the dimension.And the table would not have the same apperance.thank you anyway

Re: two fields in one dimension

Tue, 08 Jul 2014 16:03:38 GMT

Hy Gysbert ,

I think this turn arround works for me.

thank you!