topic Showing data in chart in QlikView

Showing data in chart

deepakqlikview_123 — Tue, 13 Oct 2015 06:11:41 GMT

Hi All,

PFA

Below is condition.

For max year if quarter is Q4 is present then show annual data otherwise show quarterly data.

For all years except max year show annual data

We have applied some logic to get result. It seems fine.

Can you please suggest on this.

Thanks

Anonymous — Tue, 13 Oct 2015 06:30:15 GMT

Hi deepak ,

You can right the condition like this ,

if(Year=max(year)<>'Q4',Quarter,

if(Year= max(year-1),Year)

Like this using 'if' condition based on selections with using sets.

I suggest like this if possible .

I will try another way and let u know

thanks ,

Bunny