Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
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!