Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

j_schmidt
Contributor

Filtering & zero values

Hi!

I have a little question to filtering values.

I have a time dimension where i generated values for every day from 2010 up to 2017.

Furthermore i have a metric which is linked to a day in this time dimension.

Now i built a line chart where i display my metric over this time dimension.

On some days/day ranges there is no metric - in the line chart for that day a '0' is displayed.

For example:

day 1 = 10

day 2 = 15

day 3 = 0

day 4 = 0

day 5 = 22

This is exactly what i want - i want to see time ranges with 0 in my line chart, everything perfect until here.

However, if i filter another dimension connected to my metric, the time dimension with 0 is not displayed anymore.

day 1 = 10

day 2 = 15

day 5 = 22

Can somebody tell me what the best way to tackle this problem is?

I want the 0-ranges but i want to filter at the same time.

Thanks a lot!

3 Replies
MVP
MVP

Re: Filtering & zero values

May be try adding Avg({1} 0) to you expression and see if this works

RangeSum(Expression, Avg({1} 0))

j_schmidt
Contributor

Re: Filtering & zero values

Sorry, that didnt work.

I understand the behavior of the filtering.

If i filter a dimension and there is no value for that day, then that day wont be displayed.

Especially for date ranges it would be great to see in some cases (like mine now) where there are no values.

If i cant set that in Qlik i would have to to a JOIN on the database layer to actually generate a zero for these days

but there must be a simpler way no?

MVP
MVP

Re: Filtering & zero values

Would you be able to share a sample to play around with? This might work and you might have to go back to the script... but may be we can find a work around here