Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

khanashique
Contributor II

Bar Chart using Date as Dimension

Hi Experts,

I need to create bar graph with missing dates and dates in nearby future, as shown in below example:Capture.JPG

 

 

By Using current expression -> Sum({<Year = {"$(=Year(Today()))"},IDATE = {">=$(=Date(Monthstart(Today())))<=$(=Date(Monthend(Today())))"}>}Sales), i get the data till today only.

 

Thanks,

MAK.

 

4 Replies
Channa
Valued Contributor III

Re: Bar Chart using Date as Dimension

check your IDATE as data till the end of the month or till today

 

in dimension check box allow null value 

Channa
khanashique
Contributor II

Re: Bar Chart using Date as Dimension

Thanks for your reply, I want to use expression in dimension.

Channa
Valued Contributor III

Re: Bar Chart using Date as Dimension

ur expression is good just do this attach

Channa
khanashique
Contributor II

Re: Bar Chart using Date as Dimension

Thanks, i know this... but still it does not show the date where data is not available