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: 
Ed
Contributor III
Contributor III

bar chart year to date

Hello,

I would like to have on my bar chart diagram on x-axis only the value of the current year at any time and on the y-axis the amount of sales from the begining of the year, the amount on the same period last year, and the amount of the budget for this period. 

These are the formula I use currently use :

Dimension : Annee
Measure 1 : Sum(Sales)
Measure 2 : Sum({$<Annee={"$(=Year(Today())-1)"}>}Sales)
Measure 3 : Sum(Budget)

And it's not working --'

Do you have an idea ? Thanks
Have a nice day

1 Reply
Channa
Specialist III
Specialist III

Sum({$<Annee={"$(=Year(Today())-1)"}>}Sales)

 

it will always show previous year even if you select 2017 also it will not change

can you share APP

instead of Today pass variable (vYear)

Channa