Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear Qlik,
Please suggest on this.
Here i have months and trend analysis in Bar chart
Dimension-> Month,
Expression - >
round(count({<Date={"$(=max(Date))"},[Difference Category]={'7Days'}>} DISTINCT Items)/
Count(DISTINCT{<Date={"$(=max(Date))"}>} Items *100,0.01,0).
I can able to see only recent month bar.
Please find the below screen shot for your reference.
i should see the sep and aug months with calculation of the maximum date of that particular month. Please advice how to overcome this,
Thanks in Advance.
Now I see the point. So, there are many ways how to get max day of the month, but I prefer to add one more column as flag of max day.
And then use a simple set analysis condition: end_month = {1}
hope this way will be suitable for you
Hello!
Improve your set condition with Addmonths function:
Date={">$(=monthstart(Addmonths(max(Date),-2)))"} if your month field ends with the last day of month.
Thanks Sergey,
Thanks for your response.
I tried with this one but values are not correct. It taking entire month data not max date of the month.
Please find the below screen shot and attached QVW as well.
Thanks in advance.
Now I see the point. So, there are many ways how to get max day of the month, but I prefer to add one more column as flag of max day.
And then use a simple set analysis condition: end_month = {1}
hope this way will be suitable for you
Thanks for your great help.
It's working good. Thanks once again.