Calculated Dimension IF statament

[#1]

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

[#2]

Hi,

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

Best,

Robert

[#3]

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.

[#4]

Hi,

Only for Week

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

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

Best,

Robert

[jyothish8807]

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

KC

[#6]

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.) .

[#7]

Hi,

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

or

Can i get the your sample QVW file.

Best,

Robert

[#8]

Please find my sample qvw file

Thanks

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

Cheers