topic Re: Pivot table sort order in QlikView

Pivot table sort order

polisetti — Fri, 21 Feb 2014 22:02:10 GMT

Hi I have a pivot table in which i am having expressions like Market Rx,Market share and Decile for different brand.In which the Market Rx is same for all the brands.So I dont want to show Market Rx for every brand.So i want to show Market Rx expression seperate of that group of expressions.

I want show like this ...Can it be possible in pivot table?

Header 2	Header 3	Header 4
Brand	ABC	DEF
Market Rx	Market share Decile	Market Share Decile
24	334 D1	123 D2
50	234 D1	454 D2

Please check screen shot....

Re: Pivot table sort order

chiru_thota — Fri, 21 Feb 2014 22:14:43 GMT

Hi ,

It is not possible directly.

May be you can try to make Market Rx as calculated dimension.So that it won't repeat for each brand.

Thanks,

Chiru

Re: Pivot table sort order

polisetti — Mon, 24 Feb 2014 06:29:22 GMT

Ya i tried it ,but it is showing error in calculated dimension.As in market Rx i used a set analysis and it is a complex expression .I think it will not work in calculated dimension.

Re: Pivot table sort order

sujeetsingh — Mon, 24 Feb 2014 06:36:57 GMT

As per my knowledge the pivot table first do sorting on dimension and then expressions

Re: Pivot table sort order

sundarakumar — Mon, 24 Feb 2014 06:38:23 GMT

Plese post the expression(calculated dimension) , i think it should work..

-Sundar

Re: Pivot table sort order

polisetti — Mon, 24 Feb 2014 06:51:43 GMT

Ok just try this...

(IsNull(SUM(TOTAL<[Customer Name]> {<[_Time Bucket Type]={'CURR'},[Brand Name]=,[Astellas Brand]=>}[XPO Product Sales])),'',
(SUM(TOTAL<[Customer Name]> {<[_Time Bucket Type]={'CURR'},[Brand Name]=,[Astellas Brand]=>}[XPO Product Sales])))

Re: Pivot table sort order

chiru_thota — Mon, 24 Feb 2014 22:10:22 GMT

Can you share your application if possible ?

So that I can try some thing.

Thanks,

Chiru