Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Please post a qlikview document with example data.
@hi Mohammad,
try it
If(getselectcount(Month)>0,Sum({<MonthId={$(=Max(Monthid)-1)},Monthid=>}amount),sum(amount))
Thankz...its working...
In case of April as Current month, it should show March month of previous fiscal year data...
Regards,
Mohammad
In case of April as Current month, it should show March month of previous fiscal year data...
Regards,
Mohammad.
Can you provide some sample data?
PFA..