topic Re: SET Analysis with left function in QlikView

SET Analysis with left function

tamilarasu — Tue, 23 Jun 2015 03:12:29 GMT

Hello All,

I am trying to change an expression from If condition to Set analysis. I have tried the below expression and it seems not working.

Only({$<Left(%HLINK,2)={'*'}-{'00'}>}MA_ENHANCED.MNR)

Could any one guide me.

Tue, 23 Jun 2015 03:18:05 GMT

Hi Nagraj,

Here Left(%HLINK,2) will give '%H' as result.

Is there any field having name as '%H'?

Can you please explain your requirement clearly?

Thanks

Harsha Nandan

tamilarasu — Tue, 23 Jun 2015 03:37:01 GMT

Hi Nandan,

%Hlink is a field. Below is my actual expression and I want to modify the expression with set analysis.

If((Left(%HLINK,2)<>'00' and PR.KO='900' and PR.KS='ZF') or (Left(%HLINK,2)='00' and PR.KO='901' and PR.KS='ZF') ,

MA_ENHANCED.MNR)

But it seems left function not working in set analysis.

danieloberbilli — Tue, 23 Jun 2015 03:41:05 GMT

Can you post your if-function?

Maybe you should consider to create a new field in the script like eg.

...

left(%HLINK,2) as %HLINK_2left,

...

I guess it should be sth like:

Only({<%HLINK_2left={“*”} – {'00'}>} MA_ENHANCED.MNR)

it must be double quote for the star-symbol as you are "searching" and not looking up a 'value'

jagan — Tue, 23 Jun 2015 03:50:48 GMT

Hi,

Try this

Only({<%HLINK-={'00*'}, PR.KO={'900'}, PR.KS={'ZF'}> + <%HLINK={'00*'}, PR.KO={'901'}, PR.KS={'ZF'}>} MA_ENHANCED.MNR)

tamilarasu — Tue, 23 Jun 2015 04:38:37 GMT

Jagan,

Thank you.

Daniel,

I don't want to touch the data model as it was created already. Thanks for your help.