topic Re: Help With Pivot Table in QlikView

Help With Pivot Table

Thu, 27 Mar 2014 11:56:50 GMT

Dear Community

I am Attaching sample file..how to find the Total Sales,and Rank in pivot table...

I dont want to use calculated dimensions..so i want to this one in pivot table with some useful expression.

i want to show only in pivot table.

can u please help me .

Re: Help With Pivot Table

sudeepkm — Thu, 27 Mar 2014 12:13:34 GMT

Please take a look at the attachment.

Re: Help With Pivot Table

Thu, 27 Mar 2014 12:18:14 GMT

First select the chart pivot table => in the dimension place first the Product then Customer => Next in Expression Put Sum(Sales).

After that go to sort tab and sort according to the way you want

Re: Help With Pivot Table

Thu, 27 Mar 2014 12:36:48 GMT

sudeepkm

Dear Sudeep,Thanks For giving reply..

But i want to use all the dimensions i am having,for example here i have two dimension,in other case i have 5 dimensions ,

if i do like this i am getting rank 1 for all the persons when i expand the symbol,When I use collapse all button i am getting the Rank what u said ...

So Please kindly correct me the error

Re: Help With Pivot Table

Thu, 27 Mar 2014 12:44:23 GMT

hi,

what u r saying is it correct way???

i have to find the rank. in pivot table

Re: Help With Pivot Table

sudeepkm — Thu, 27 Mar 2014 12:47:28 GMT

The rank is based on the sum(Sales) so if your sum(Sales) is same for more than one Field values then the rank will show same for all those field values.

If possible can you please post the sample where you are getting any issue?

Re: Help With Pivot Table

Thu, 27 Mar 2014 13:00:05 GMT

Dear Sudeep

U r way doing is exactly correct ..but i am not getting in the same way.if i am doing.i have 5 dimensions sudeep,

how can i do it..it is not possible to add a sample qvw ..so please understand and let me give the solution...

i have different sum(sales) are there ..