topic Re: left function in set analysis in QlikView

left function in set analysis

Anonymous — Wed, 30 Dec 2015 10:15:13 GMT

hello,

how to use left function in set analysis if i have multiple conditions-

for example

if(left(item,2)=22 or if(left(item,2)=24 and so on.. then sum the sales

i want to write it in set analysis so that in any case it will show me the sales of those items.

thanks!

Anonymous — Wed, 30 Dec 2015 13:02:15 GMT

may be this?

=sum({<Item={'22*','24*'>} Sales)

HirisH_V7 — Wed, 30 Dec 2015 13:02:47 GMT

Hi,

You can use left function and modify your dimension as required in back-end and call it in front end into set analysis .

Check this ,

To pick desired record.

Hope this Helps,

Thanks,

Hirish

Anonymous — Wed, 30 Dec 2015 13:07:43 GMT

Thanks again Balraj

sunny_talwar — Wed, 30 Dec 2015 13:35:23 GMT

Just for record purposes, you are missing a curly bracket:

=Sum({<Item={'22*','24*'}>} Sales)

Anonymous — Wed, 30 Dec 2015 13:37:06 GMT

ohh..Okay.

sunny_talwar — Wed, 30 Dec 2015 13:38:21 GMT

Anonymous — Wed, 30 Dec 2015 13:40:36 GMT

Thank Sunny