Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
kavita25
Partner - Specialist
Partner - Specialist

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
Kushal_Chawda

Please see the attached

View solution in original post

6 Replies
Kushal_Chawda

Please provide the sample app

rubenmarin

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)

kavita25
Partner - Specialist
Partner - Specialist
Author

Check the app..

kavita25
Partner - Specialist
Partner - Specialist
Author

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

Kushal_Chawda

Please see the attached

kavita25
Partner - Specialist
Partner - Specialist
Author

Thank You...It worked