topic Re: How to get maximum Quarter based on multiple quarters selection in QlikView

How to get maximum Quarter based on multiple quarters selection

nehasaxena — Thu, 15 Jun 2017 09:30:12 GMT

Hi,

We have chart displays last 8 quarters data. It works well with single quarter selection but when we select more than one quarter it displays as "No data to Display" in chart.

The requirement is to display last 8 quarter based on maximum value from multiple selections of quarter.

Formula in Chart expression:

Sum({<Year=,Quarter=,Month=, Week=,DateType={'Transaction'}, CanonicalDate={">=$(=QuarterStart($(vQtr),-8))<=$(=QuarterEnd($(vQtr)))"}>}NumberofPolicies)

Where vQtr -

If(QuarterNo=1,makedate(Year),If(QuarterNo=2,makedate(Year,04),If(QuarterNo=3,makedate(Year,07),If(QuarterNo=4,makedate(Year,10)))))

Please suggest me how to get the maximum quarter based on multiple value selection.

Regards

Neha

Re: How to get maximum Quarter based on multiple quarters selection

kaushiknsolanki — Thu, 15 Jun 2017 09:35:05 GMT

You will have to modify your variable value.

Try below.

If(Max(QuarterNo)=1,makedate(Year),If(Max(QuarterNo)=2,makedate(Year,04),If(Max(QuarterNo)=3,makedate(Year,07),If(Max(QuarterNo)=4,makedate(Year,10)))))

Regards,

Kaushik Solanki

Re: How to get maximum Quarter based on multiple quarters selection

sunny_talwar — Thu, 15 Jun 2017 11:57:05 GMT

Or try this

vQtr = MakeDate(Year, (3*Max(QuarterNo))-2)

Re: How to get maximum Quarter based on multiple quarters selection

nehasaxena — Thu, 22 Jun 2017 04:12:07 GMT

Thanks Kaushik, It worked, I didnt knew it was so simple