topic Re: CASE STATEMENT IN QLIKVIEW in QlikView

CASE STATEMENT IN QLIKVIEW

satishkurra — Thu, 08 Sep 2016 16:52:03 GMT

I'm trying to convert the below case statement into QlikView.

Can someone help me on the same?

case

when "ProductID1" in ('1','2','3','4')

or "ProductID2" in

('6','7','8','9')

then 'ProductGroup1'

else 'ProductGroup2'

end

Thanks

Satish

Re: CASE STATEMENT IN QLIKVIEW

sunny_talwar — Thu, 08 Sep 2016 16:55:56 GMT

May be like this:

If(Match(ProductID1, 1, 2, 3, 4) or Match(ProductID2, 6, 7, 8, 9), 'ProductGroup1', 'ProductGroup2') as ProductGroup

Re: CASE STATEMENT IN QLIKVIEW

satishkurra — Thu, 08 Sep 2016 18:17:17 GMT

Sunny

Just a question out of curiosity, can't we use Pick in place of If?

Re: CASE STATEMENT IN QLIKVIEW

satishkurra — Thu, 08 Sep 2016 18:17:39 GMT

Sunny

Just a question out of curiosity, can't we use Pick in place of If?

Re: CASE STATEMENT IN QLIKVIEW

sunny_talwar — Thu, 08 Sep 2016 18:22:09 GMT

I don't think Pick will be easy, but here is another option

If(WildMatch(ProductID1&'|'&ProductID2, '1|*', '2|*', '3|*', '4|*', '*|6', '*|7', '*|8', '*|9'), 'ProductGroup1', 'ProductGroup2') as ProductGroup