topic Calculated Dimension question in QlikView

Calculated Dimension question

Thu, 04 Jul 2013 08:55:01 GMT

Hi,

I'm working with version 11.

as a calculated dimension I use the following:

= if( Week_End_Flag = 1, BacklogYearWeek)

So year/week is displayed on the X-axis.

What happens is that the sum of values with no defined week is displayed as well.

See attached picture.

Any ideas how to prevent this value?

Thanks!

sujeetsingh — Thu, 04 Jul 2013 09:09:21 GMT

You can write the expression to label this null value with "No WEEK".

Gysbert_Wassenaar — Thu, 04 Jul 2013 09:15:34 GMT

Enable the Suppress When Value Is Null option for your calculated dimension.

er_mohit — Thu, 04 Jul 2013 09:17:36 GMT

either you can check on suppress null value in dimension tab for that particular dimension and in dimension limit tab check on show total

hope it helps