Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Conditional Dimension

Hello,

I am working on building the following chart.

Capture.PNG

Everything is fine with this chart except that all the dates that don't have any data are showing as 0. I would like this graph to only show data for dates that have data. I update this chart on a Period basis, so there is no need to have all these excess dates that don't yet have data.

Current Dimensions:

Dimensions.PNG

Current Measure:

Measure.PNG

Can anyone provide any insight on how I might do this?

Thanks!

Randall

2 Replies
MVP
MVP

Re: Conditional Dimension

Try disabling the option 'show NULL values' (or similar wording) on you chart properties - add ons - data handling.

Not applicable

Re: Conditional Dimension

Thanks swuehl. That worked for that particular chart. But I actually have another chart that un-checking that option didn't work for. Any ideas for this one?

1.PNG

2.PNG

Community Browser