Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
zied_ahmed1
Specialist
Specialist

Problem with vRange

Hello i have this graph and i uset vSetPeriod Range :

rangeeee.png

I would like Now to display for 2016 and 2015 just the value to this date (value to April 2015 and value April 2016) :

VsetYearlyRange : [Calendar date]=,[Year of date] = ,[Month of date]=, [Year of date] = {"> $(=max([Year of date]) - $1)  <= $(=[Year of date])"},[%Date ID] = { "<= $(=max([%Date ID]))"}

vSetMonthlyRange : [Calendar date]=,[Month of date]=, [Year of date]=, [%Year month SEQ] = {"> $(= max([%Year month SEQ]) - $1)  <= $(=[%Year month SEQ])"}

Regards

3 Replies
zied_ahmed1
Specialist
Specialist
Author

rahulpawarbstalwar1

any solution please?

Regards

rahulpawarb
Specialist III
Specialist III

Hello Zied,

At primary level of understanding, you can change the upper bound for [Year of date]  & [%Date ID] to get the desired results. BTW, Could you please share the application with sample data?

Regards!

Rahul

vlad_komarov
Partner - Specialist III
Partner - Specialist III

Zied,

How your data is organized? Do you have any data points beyond the Today()?

Some data sample would be helpful to build the desired Measure for your chart...

Regards,

Vlad