topic Re: Missing Dimension in QlikView

Missing Dimension

Wed, 09 Apr 2014 19:06:49 GMT

I want to populate a dimension even if it's missing in a year.

For example

In 2014 I have six models with sales

But in 2013 I only show 5 models because there are no sales for the sixth group. The users still want to see the group but with 0.

And when I do percentage change from 2014 to 2013 the sixth model is not shown because in 2013 the group is not there.

But instead they want to see 100% increase/change in 2014 since no sales for that model in 2013.

MK_QSL — Wed, 09 Apr 2014 19:28:48 GMT

Like this?

whiteline — Wed, 09 Apr 2014 19:33:47 GMT

Hi.

So you have to add these zeros to your data model.

its_anandrjs — Wed, 09 Apr 2014 19:35:36 GMT

Use suppress when value null in the chart and uncheck from the chart properties.

Wed, 09 Apr 2014 19:41:35 GMT

You are correct except that the previous year and current year are filter selections.

So Model is a dimension and I am counting sales with expression

=sum( sales) -- for current year

=sum({<season=,season=[Previous]>} sales) -- Previous year

= (sum(sales)- sum({<season=, season=[Previous]>} sales))/ sum({<season=, season=[Previous]>} sales) -- Percentage or difference between two years

Wed, 09 Apr 2014 19:42:13 GMT

I thought about this but did not try. I can try it and let you know.

Wed, 09 Apr 2014 19:42:50 GMT

I tried it does not help.

MK_QSL — Wed, 09 Apr 2014 19:50:09 GMT

TRY

ALT((sum(sales)/sum({<season=, season=[Previous]>} sales))-1,1)

Wed, 09 Apr 2014 20:28:06 GMT

use populate missing cells in chart properties