left function in set analysis

[Anonymous]

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 · Accepted solution]

may be this?

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

[HirisH_V7]

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 ,

Qlik Design Blog : String Functions | Qlik Community

• Left(YourFieldName, 3)  as [New Field Name]

To pick desired record.

Hope this Helps,

Thanks,

Hirish

[Anonymous]

Thanks again Balraj

[sunny_talwar]

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

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

[Anonymous]

ohh..Okay.

[sunny_talwar]

[Anonymous]

Thank Sunny