Year or month to dates

[devender]

hi,

I am new to qlik and here i have question.

I have data in months suppose.i have to make bar chart,sales vs date.which means if i select a customer the data i wanted is to show sales till date.

[G3S]

hi,

you could try set analysis:

Sum({$<yourdatefield={'$(<=today())'}>}Sales)

[devender]

thx for reply.i think i have confused you.let me try to make it clear.data in my server is in month now i wanted covert that months into dates so that i can make chart date as dimension and sales as measures.

[sidhiq91]

@devender I guess you might need to create a master calendar that would help you to create dates, months etc.

Please see below link to create a master calendar.

https://community.qlik.com/t5/QlikView-App-Dev/How-to-Create-Master-Calendar/td-p/103109

[devender]

okay @sidhiq91 ,

assume i am done with master calender.so what would be further process

[sidhiq91]

@devender You can use that date as Dimension and sales as Measure to create a Bar chart.