topic Re: Expression in group does not response correctly. in QlikView

Expression in group does not response correctly.

yanivvl0 — Wed, 01 Feb 2017 08:50:24 GMT

hi to all ,

i have a group that contains 2 members the first ia an exprission , the expression check if there is a special string in the field DocumentName , if so it gets a hard-code string , else it gets other field value ( name in Hebrew ) - that way it union values like

"tochnitavoda2015" , "tochnitavoda2016" , "tochnitavoda2017" to one value "תכניות עבודה" :

if ( DocumentName like '*tochnit*' , 'תכניות עבודה' , SubMenu )

it works ok , when i try to drill down to the lower level in the group from 'תכניות עבודה' then i get values equal to a selection

SubMenu = 'תכניות עבודה' :

before drill down :

after drill down :

Thanks for your help !!

Re: Expression in group does not response correctly.

sunny_talwar — Wed, 01 Feb 2017 10:22:31 GMT

Would it possible for you to share a sample to look at this issue Yaniv?

Re: Expression in group does not response correctly.

yanivvl0 — Wed, 01 Feb 2017 13:34:27 GMT

hi Sunny ,

its a bit problem - its the performence model , and there is sensitive data in it ( user names .. )

i will be glad to make things more clear , if you have any questions on any subject,

as always - thanks a lot!

Re: Expression in group does not response correctly.

sunny_talwar — Wed, 01 Feb 2017 14:02:14 GMT

May be scramble the data before sharing?

Preparing examples for Upload - Reduction and Data Scrambling

Re: Expression in group does not response correctly.

yanivvl0 — Tue, 07 Feb 2017 08:34:45 GMT

HI Sunny , i solve the problem in the DB layer - Thanks!!