topic Re: GetFieldSelections in Setanalysis in QlikView

GetFieldSelections in Setanalysis

Thu, 22 Aug 2013 04:26:49 GMT

Hi Community Experts,

Can I get the below expression fully in set analysis without using if condition.

IF(GetFieldSelections(Product,';')='AA;BB' or GetFieldSelections(SubProd,';')='AAA;BBB',SUM({$<ProdType-={'SmartPhone'}>}Amount),

IF(GetFieldSelections(Product,';')='CC;DD' or GetFieldSelections(SubProd,';')='CCC;DDD',SUM({$<ProdType-={'Mobile'}>}Amount),

SUM({$<ProdType-={'SmartPhone','Mobile'}>}Amount)))

Thanks lot

Re: GetFieldSelections in Setanalysis

Oleg_Troyansky — Thu, 22 Aug 2013 04:55:26 GMT

No, I don't think you can fit this condition in Set Analysis, or at least not without revealing more associations between Product, SubProd and ProdType. If I understand your expression, you are excluding different ProdTypes based on the field selections in Product and SubProd.

I'd try and build associations in the data that could drive the same behavior. It looks like some of those associations might be missing and you are trying to compensate by using IF and Set Analysis.

Having said that, this IF statement is not too bad, because it's outside of the SUM, and therefore it's only performed once per chart line.

Re: GetFieldSelections in Setanalysis

kumarnatarajan — Thu, 22 Aug 2013 05:05:26 GMT

Hi,

I think if condition not bad for your case.But you can able to store the excluding ProdTypes values in variable based on your condition.

Ex: vExclude="Your Condition";

=SUM({$<ProdType-={$(vExclude)}>}Amount)

Re: GetFieldSelections in Setanalysis

Thu, 22 Aug 2013 05:48:42 GMT

Hi All,

I have converted the expression into if condition fully. Its working fine in expression window. But if I substitute variable then I am always getting last condition true.

$(Variable) if I write it in expression window of chart its giving always last part of expression.

Variable=

sum(IF(GetFieldSelections(Product,';')='AA;BB' or GetFieldSelections(SubProd,';')='AAA;BBB' and ProdType<>'SmartPhone') or

(GetFieldSelections(Product,';')='CC;DD' or GetFieldSelections(SubProd,';')='CCC;DDD' and ProdType<>'Mobile') or

(ProdType<>'SmartPhone' and ProdType<>'Mobile'), GrasRevenueUSD))

Re: GetFieldSelections in Setanalysis

jagan — Thu, 22 Aug 2013 06:01:08 GMT

Hi,

Try like this

Create a variable with the below expression

vExcludeValues
=IF(GetFieldSelections(Product,';')='AA;BB' or GetFieldSelections(SubProd,';')='AAA;BBB','SmartPhone',

IF(GetFieldSelections(Product,';')='CC;DD' or GetFieldSelections(SubProd,';')='CCC;DDD','Mobile',

'SmartPhone,Mobile'))

Now use this variable value in set analysis expression.

=SUM({$<ProdType-={$(vExcludeValues)}>} Amount)

Regards,

Jagan.

Re: GetFieldSelections in Setanalysis

Thu, 22 Aug 2013 06:12:30 GMT

Hi Jagan,

Thanks for your reply.

The expression provided by you is not fulfils the required.

I want to have everything in a variable. In the expression window I want to have only variable name.

Like $(Variable)

I have solved the issue with if condition itself. But now the issue is to put in variable and to use.

Can you provide me the modified variable value accordingly.

Re: GetFieldSelections in Setanalysis

jagan — Thu, 22 Aug 2013 06:26:35 GMT

Hi,

Then in variable don't use =, then in expression box use like this

=$(VariableName)

If you use = in variable declaration then it evaluates the expression and you will get single value in expression,

Hope this helps you.

Regards,

Jagan.

Re: GetFieldSelections in Setanalysis

ilanbaruch — Mon, 07 Sep 2015 09:51:31 GMT

hi,

I read your comment and loaded exclude value to a variable (GetFieldSelections )

and then the variable into text box and its working, but

when loading into SA it is not working

SUM({$<(category)-={$(vExclude)}>}Quantity )

any ideas?

Re: GetFieldSelections in Setanalysis

jagan — Mon, 07 Sep 2015 10:26:00 GMT

Hi,

Create a new thread and attach some sample file with your expected output.

Regards,

Jagan.

Re: GetFieldSelections in Setanalysis

ilanbaruch — Mon, 07 Sep 2015 14:23:08 GMT

Hi,

Check out 'GetFieldSelections + SetAnalisys' in Qlik Community.

Re: GetFieldSelections in Setanalysis

ilanbaruch — Tue, 08 Sep 2015 09:30:32 GMT

Hi,

Check out 'GetFieldSelections + SetAnalisys' in Qlik Community.