topic Re: How to use if with GetFieldSelections? in QlikView

How to use if with GetFieldSelections?

Tue, 19 Aug 2014 11:42:17 GMT

Hi,

I This data:

Designation

SSE

I have taken a variable vDesigation, Wherein variable overview I have taken...

vDesignation=if(IsNull(GetFieldSelections(Designation)),'Overall',if(GetFieldSelections(Designation)= 'SA' or GetFieldSelections(Designation)='SE' or GetFieldSelections(Designation)='SSE','Low','High'))

This is not working.

I am Printing the value of vDesignation in text box, Where if SA or SE or SSE is selected in the designation filter it should display Low else High.

Thanks in advance,

Pratik

Re: How to use if with GetFieldSelections?

senpradip007 — Tue, 19 Aug 2014 11:50:24 GMT

Try this

if(GetFieldSelections(Designation)= 'SA' or GetFieldSelections(Designation)='SE' or GetFieldSelections(Designation)='SSE','Low','High')

Re: How to use if with GetFieldSelections?

Tue, 19 Aug 2014 11:57:12 GMT

Thanks for the Reply but I am Using Isnull function to print the word overall when clear button is presses, i.e when no filters applied on the field designation

Re: How to use if with GetFieldSelections?

syukyo_zhu — Tue, 19 Aug 2014 12:02:50 GMT

you can try " $(vDesignation) " in your text object

Re: How to use if with GetFieldSelections?

p_verkooijen — Tue, 19 Aug 2014 12:04:02 GMT

Use GetSelectedCount for checking if there is a selection active for Designation

IF(GetSelectedCount(Designation)=0,....

Note that if two ore more selections are made in Designation the result will be High.

You can't check for one value with IF(GetFieldSelections(Designation), you should use index or a different type of check.

Re: How to use if with GetFieldSelections?

senpradip007 — Tue, 19 Aug 2014 12:08:50 GMT

When no filtter is applied GetSelectedCount(Designation) returns 0 and Overall will be flashed.

Re: How to use if with GetFieldSelections?

Tue, 19 Aug 2014 13:05:07 GMT

I want the syntax to check if Multiple values are selected, i.e by using if condition with GetFieldSelections

Re: How to use if with GetFieldSelections?

ssanchez — Tue, 19 Aug 2014 17:09:44 GMT

If the problem is a multiple selection in the Designation field, you can use the function SubStringCount. The variable vDesignation is defined as follows:

if(IsNull(GetFieldSelections(Designation)),'Overall',

if(substringcount(GetFieldSelections(Designation),'SA')=1

or substringcount(GetFieldSelections(Designation),'SSE')=1

or substringcount(GetFieldSelections(Designation),'SE')=1,

'Low',

'High'))

Re: How to use if with GetFieldSelections?

bgerchikov — Tue, 19 Aug 2014 17:25:22 GMT

I'd suggest to use MixMatch or Match functions:

If(getSelectedCount(Designation)=0,'Overall', If(MixMatch(GetFieldSelection(Designation),'SA','SE','SSE'),'Low','High'))

Hope it will help