topic Re: Calculated Dimension IF statament in QlikView

Calculated Dimension IF statament

Wed, 22 Oct 2014 02:06:11 GMT

Hi guys

I am very new in Qlikview and I am trying to add a calculated dimension.

=IF(YearWeek=vOpsWk,'Week',

IF(YearWeek>=vOpsWk_4 and YearWeek<vOpsWk,'MTD'

))

when the dimension generate it also return me the "else" data.

how can I avoid this? Please see the picture. I don't want the last line.

Thanks

Re: Calculated Dimension IF statament

Wed, 22 Oct 2014 02:37:04 GMT

Hi,

Check " Suppress When values is Null" option in the Dimension tab.

Best,

Robert

Re: Calculated Dimension IF statament

Wed, 22 Oct 2014 02:55:47 GMT

Thanks a lot Robert

How about if I only want to use 'Week'

Use the "Settings for Selected Dimension" if so can you please show the how this works?

Also the "IF" statement in Qlikview looks like can't avoid filter out the else at the beginning.

Re: Calculated Dimension IF statament

Wed, 22 Oct 2014 03:01:17 GMT

Hi,

Only for Week

=IF(YearWeek=vOpsWk,'Week',null())

Check " Suppress When values is Null" option in the Dimension tab.

Best,

Robert

Re: Calculated Dimension IF statament

jyothish8807 — Wed, 22 Oct 2014 03:04:58 GMT

Hi Yihang,

=IF(YearWeek=vOpsWk,Week,

IF(YearWeek >=vOpsWk_4 and YearWeek <vOpsWk,MTD))

Try this. And can please elobrate your requirment a bit more.

Regards

Re: Calculated Dimension IF statament

Wed, 22 Oct 2014 03:13:59 GMT

Hi Robert

I just tried

Only for Week

=IF(YearWeek=vOpsWk,'Week',null())

Check " Suppress When values is Null" option in the Dimension tab."

And it not work. it only filter out the last rows (same as only check " Suppress When values is Null" option in the Dimension tab.) .

Re: Calculated Dimension IF statament

Wed, 22 Oct 2014 03:18:17 GMT

Hi,

can you try something like this : =IF(YearWeek=vOpsWk,'Week')

Can i get the your sample QVW file.

Best,

Robert

Re: Re: Calculated Dimension IF statament

Wed, 22 Oct 2014 03:41:12 GMT

Please find my sample qvw file

Thanks

Btw I tried '=IF(YearWeek=vOpsWk,'Week')' and not works as well .

Cheers