topic Re: Need help for an expression in QlikView

Need help for an expression

ananyaghosh — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

For the fllowing expression;

if ([Product Type Code] = 'IN', 'MF', 'LS', [Social Code Group] = 'RET','DCIO','Non-DCIO')

I have used in an dimension for the condition is that: if the product type code is in 'IN', 'MF', 'LS', then [Social Code Group] field values will be in 'RET','DCIO','Non-DCIO'.

Please give me the correct syntax of expression for the above condition.

Thanks,

Sandip

Re: Need help for an expression

Anonymous — Wed, 23 Nov 2016 07:47:07 GMT

How do you wish to use this?

Re: Need help for an expression

hemanthaanichet — Wed, 23 Nov 2016 07:47:54 GMT

Hi Sandip,

Try this:

pick(match([Product Type Code], 'IN', 'MF', 'LS'), 'RET','DCIO','Non-DCIO')

Regards

Hemanth

Re: Need help for an expression

Anonymous — Wed, 23 Nov 2016 07:52:28 GMT

if you Need to filter [Social Code Group] in your app, you may use field Trigger to achieve

if you want e.g. a Chart to only diesplay the relevant data you may use

if match(([Product Type Code], 'IN', 'MF', 'LS'>0, if match([Social Code Group],'RET','DCIO','Non-DCIO')>0, ([Social Code Group])

or in an Expression you may use set analysis

{<([Social Code Group]={'RET','DCIO','Non-DCIO'}>}

Re: Need help for an expression

vinieme12 — Wed, 23 Nov 2016 07:52:40 GMT

is this an expression or calculated dimension?

This should be your calculated dimension

if(Match([Product Type Code], 'IN', 'MF', 'LS'),[Social Code Group])

the second part should be part of your expressions in set analysis

,[Social Code Group] = {'RET','DCIO','Non-DCIO'}

Re: Need help for an expression

ananyaghosh — Wed, 23 Nov 2016 07:55:43 GMT

I have used [Social Code Group] field in an dimension and use the condition like this: if the product type code is in 'IN', 'MF', 'LS', then [Social Code Group] field values will be in 'RET','DCIO','Non-DCIO'.

So my previous expression is : if ([Social Code Group] = 'RET','DCIO','Non-DCIO')

which means field value of [Social Code Group] will only include 'RET','DCIO','Non-DCIO' and these values can be used.

Now, please tell me what will be the set expression?

Re: Need help for an expression

ananyaghosh — Wed, 23 Nov 2016 08:02:46 GMT

So my previous expression is : if ([Social Code Group] = 'RET','DCIO','Non-DCIO')

which means field value of [Social Code Group] will only include 'RET','DCIO','Non-DCIO' and these values can be used.

Now, please tell me what will be the set expression? or the if statement?

your if statement does not work for me:

if match(([Product Type Code], 'IN', 'MF', 'LS'>0, if match([Social Code Group],'RET','DCIO','Non-DCIO')>0, ([Social Code Group])

Please give me the correct ones.

Re: Need help for an expression

ananyaghosh — Wed, 23 Nov 2016 08:04:08 GMT

AS I am using Qliksense there is no option for calculated dimension.

Please

So my previous expression is : if ([Social Code Group] = 'RET','DCIO','Non-DCIO')

which means field value of [Social Code Group] will only include 'RET','DCIO','Non-DCIO' and these values can be used.

Now, please tell me the if statement if you can?

Re: Need help for an expression

vinieme12 — Wed, 23 Nov 2016 08:09:11 GMT

https://help.qlik.com/en-US/sense/3.1/Subsystems/Hub/Content/Dimensions/calculated-dimensions.htm

Refer the link above

use the below in dimension

=if(Match([Product Type Code], 'IN', 'MF', 'LS'),[Social Code Group])

and below should be part of set analysis in all expressions of the chart

[Social Code Group] = {'RET','DCIO','Non-DCIO'}

Re: Need help for an expression

saimahasan — Wed, 23 Nov 2016 08:13:32 GMT

You can use this expression:

=If(Match([Product Type Code],'IN','MF','LS'),[Social Code Group])

in you dimension.

Re: Need help for an expression

hemanthaanichet — Wed, 23 Nov 2016 09:25:52 GMT

Hi Sandip,

Your requirement is whenever [Product Type Code]=IN,MF,LS then [Social Code Group] = RET,DCIO,Non-DCIO

so you can use pick and match in your expression

match([Product Type Code], 'IN', 'MF', 'LS') which fetch IN, MF, LS

It will perform whenever IN MF LS comes RET DCIO Non-DCIO will appear

Try this:

pick(match([Product Type Code], 'IN', 'MF', 'LS'), 'RET','DCIO','Non-DCIO')

May this i think so:

if (match([Product Type Code], 'IN', 'MF', 'LS'),match([Social Code Group] , 'RET','DCIO','Non-DCIO'),[Social Code Group])

Regards

Hemanth

Re: Need help for an expression

hemanthaanichet — Wed, 23 Nov 2016 09:45:52 GMT

Hi Sandip

I tired with sample data

pick and match expression is working fine

if statement is not upto desired

Attached a qvw for the reference

Regards

Hemanth