topic Re: Question on Pivot table in QlikView

Question on Pivot table

chamarthiprathy — Tue, 06 Jun 2017 10:12:54 GMT

Please let me know how to create month wise data in the pivot table for only one year which is current year??

Re: Question on Pivot table

sunny_talwar — Tue, 06 Jun 2017 11:29:43 GMT

Add Month as dimension and something like this in your expression

Sum({<Year = {$(=Max(Year))}>}Measure)

Re: Question on Pivot table

chamarthiprathy — Wed, 07 Jun 2017 05:36:10 GMT

Above expression is not helpful. Using this expression, am only getting Max year. My requirement is should get all years along with current year month wise data

If([Section] = ' Medicines', sum({<Year={$(=Max(Year))}>}Measure))

Re: Question on Pivot table

prma7799 — Wed, 07 Jun 2017 05:41:14 GMT

Please share some sample application

Re: Question on Pivot table

Anil_Babu_Samineni — Wed, 07 Jun 2017 05:41:39 GMT

May be this?

If([Section] = ' Medicines', sum({<Year={"<= $(=Max(Year))"}>}Measure)

If([Section] = ' Medicines', sum({<Year={"$(= '<=' & Max(Year))"}>}Measure)

Re: Question on Pivot table

Anonymous — Wed, 07 Jun 2017 06:02:36 GMT

I think this is helpful to you.

Take Dimensions Year as first dimension and Month as second dimension,

add expression like this Sum({<Year = {$(=Max(Year))}>}Measure) in Pivot table.

Re: Question on Pivot table

chamarthiprathy — Wed, 07 Jun 2017 06:41:02 GMT

Hi All,

Example: I have 4 Years data 2014,2015,2016,2017.. I want Display Only Current Year Month wise Sales renaming years want to display years wise .. If Fiscal year is Starts from July to June .. Now Current month is May now i want display June Month as Empty in Pivot as Current Month June See Reference date:

Current Month Year in Pivot:

2017

July Aug Sep Oct Nov DEC Jan Feb Mar Apr May Jun AVG

100 200 300 400 500 600 700 800 900 1000 1100 - 6600/12=550

Can you please help me asap guys..

Thanks,

Rajesh..

Re: Question on Pivot table

sunny_talwar — Wed, 07 Jun 2017 10:54:29 GMT

Your initial post and your response is not helpful and waste of my time.... should I say that to you? I am sorry, but based on your initial response, I was not able to offer more than what I did.... Please look here

How to get answers to your post?

Preparing examples for Upload - Reduction and Data Scrambling