Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
Partner
Partner

How can I show last to last month value in current month in Line chart

Hi,

I want to show trend Month wise, but my logic is to show Last to last  month value in current value if the day is less than 7.

I am able to do it in text box but not in Line Chart

For e.g

sum Sales for Jun is 200

and Current Month is August date 07/08/2015

so the sum of sales for Aug month should be 200

Hope you understand and provide me with great solution.

Regards,

Kavita

1 Solution

Accepted Solutions
Highlighted

Re: How can I show last to last month value in current month in Line chart

Please see the attached

View solution in original post

6 Replies
Highlighted

Re: How can I show last to last month value in current month in Line chart

Please provide the sample app

Highlighted

Re: How can I show last to last month value in current month in Line chart

Hi Kavita, hope this expression helps you:

If(Day(Max(Date))>=7, Sum(Sales),

     Above(Sum(Sales))) // This gets your previous loaded month (for 07/08 will get Jul)

Highlighted
Partner
Partner

Re: How can I show last to last month value in current month in Line chart

Check the app..

Highlighted
Partner
Partner

Re: How can I show last to last month value in current month in Line chart

Above( sum(Sales),2) gave me the values for June This is for below 7.

Also I want for Above 7 or equal to 7 it should give me the values for Jun

Highlighted

Re: How can I show last to last month value in current month in Line chart

Please see the attached

View solution in original post

Highlighted
Partner
Partner

Re: How can I show last to last month value in current month in Line chart

Thank You...It worked