Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
cancel
Showing results for 
Search instead for 
Did you mean: 
denis115
Creator
Creator

set analysis

Hi everyone!

I'm stucked...

Having dimension DBZ (sales-costs) that is calculated in script

I need to create a chart that will show current(selected date)  dbz, 1-30 days before dbz, 31-60 days  before dbz and so one,

Ive tried:  sum({$<DATE= {">$(=MAX(DATE-60))<$(=MAX(DATE)-31))"}> } DBZ)

and no results(((

help please

6 Replies
sunny_talwar

May be this

Sum({$<DATE = {">$(=Date(Max(DATE)-60))<$(=Date(Max(DATE)-31))"}>} DBZ)
denis115
Creator
Creator
Author

Ive tried this but it didnt worked

denis115
Creator
Creator
Author

Sum ( {<Month_NUM={"$(=max(Month_NUM)-1)"}>}DBZ)

 

where Month_NUM is number of month but its not good because when i will choose january it will not work

sunny_talwar

So use MonthYear instead... and use AddMonths() function to go back months

denis115
Creator
Creator
Author

Sum({$<MonthYear = {">$(=max( MonthYear ))<$(=max( MonthYear )+29)"}>} DBZ)

doesnt work(

sunny_talwar

You need to provide more details as to how are you creating MonthYear in the script?