if current month is selected then show previous month data or else show for all months.

[mohammadkhatimi]

Hello everyone...

I want to show data on the basis of selection i.e.

If current month is selected, then it should show previous month data or else show for all months (without selection data).

The logic is successfully implemented on text box...but not able to achieve in Chart..

Please help me to solve it...

Its urgent....

Regards,

Mohammad

[Gysbert_Wassenaar]

Please post a qlikview document with example data.

[sunilkumarqv]

@hi Mohammad,

try it

If(getselectcount(Month)>0,Sum({<MonthId={$(=Max(Monthid)-1)},Monthid=>}amount),sum(amount))

[mohammadkhatimi]

Thankz...its working...

In case of April as  Current month, it should show March month of previous fiscal year data...

Regards,

Mohammad

[mohammadkhatimi]

In case of April as  Current month, it should show March month of previous fiscal year data...

Regards,

Mohammad.

[qlikviewwizard]

Hi mohammadkhatimiti

Can you provide some sample data?

[mohammadkhatimi]

PFA..