topic Re: Need Help in QlikView

Need Help

paulwalker — Wed, 22 Jul 2015 16:02:51 GMT

HI Community,

Load * inline [

ID, Stage

100, 'Abc,123, JDB'

101, '123,BBB,JHJ'

102, 'ABC123, BCA, DCA'

103, 'CDA,JUJ,123'

];

Here, I have one Stage field, in that if i have any where 123 i want to return data.

My output should be

ID, Stage

100,123

101, 123

103,123

Thanks in Advance....

Re: Need Help

Wed, 22 Jul 2015 16:28:32 GMT

only(if(WildMatch(Stage, '123,*', '*,123', '*,123,*'), 123))

Re: Need Help

Anonymous — Wed, 22 Jul 2015 17:09:24 GMT

Hi Paul,

You can use this expression to get your desired output:

if(WildMatch(Stage, '*123*'), 123)

Hope it helps you!!

Re: Need Help

ramoncova06 — Wed, 22 Jul 2015 17:11:29 GMT

if(WildMatch(Stage, '*123*'), 123)

Re: Need Help

maxgro — Wed, 22 Jul 2015 17:12:35 GMT

Load * Where Stage='123';

Load ID, SubField(Stage, ',') as Stage

inline [

ID, Stage

100, 'Abc,123, JDB'

101, '123,BBB,JHJ'

102, 'ABC123, BCA, DCA'

103, 'CDA,JUJ,123'

];

Re: Need Help

Anonymous — Wed, 22 Jul 2015 17:26:52 GMT

Hi Paul,

You can achieve the result by Massimo Grossi Solution.

Thanks @Massimo Grossi

Re: Need Help

MarcoWedel — Wed, 22 Jul 2015 22:13:30 GMT

maybe also possible:

If(WildMatch(','&Stage&',', '*,123,*'), 123)

hope this helps

regards

Marco