Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
D19PAL
Creator II
Creator II

Start line chart to start from previous year Jan

Hi,

How can I get a line chart to start from a specific monthyear? or Better still Start line chart to start from previous year Jan.

Thanks

 

Labels (3)
1 Reply
joaopaulo_delco
Partner - Creator III
Partner - Creator III

Hi @D19PAL 

                   You need to define this in the expression of your measure using Set Analysis.

Something like below:

Sum({<FieldDate = {">=01/01/2022"}>} Revenue) 

or

Sum({<FieldDate = {">=$(=YearStart(AddYears(Today(1),-1)))"}>} Revenue) 

 

Help users find answers! Don't forget to mark a solution that worked for you!