topic Re: Multiple selection values in QlikView

Multiple selection values

santhosh_k_n — Wed, 27 Aug 2014 05:21:46 GMT

Hi All,

As per my requirement i am using variable and a if clause in multi box for filters as below,

for Geo hierarchy, Region and state, I am saving selections of region in a variable and for state multibox i am using if clause as below

if(region=V_region,State,'Please select region')

Where V_region=getfieldselections(Region)

The above is working fine for single selection made, say like if region selection is North the data in state multibox is only matching states but in case of multiple selections say North and South, the value in variable is 'North,South' and since there is no matching for same with region no data is getting displayed in state,

Please guide me

Re: Multiple selection values

AbhijitBansode — Wed, 27 Aug 2014 05:28:19 GMT

Please post sample qvw file along with the test data.

Re: Multiple selection values

PrashantSangle — Wed, 27 Aug 2014 05:30:03 GMT

Hi,

Use wildmatch() inside if()

Try like

if(wildmatch(region,V_region),State,'Please Select Region')

Regards

Re: Multiple selection values

santhosh_k_n — Wed, 27 Aug 2014 06:03:06 GMT

Hi Max,

This didn't work as the multiple selected values are saved in variable as comma separate say like 'North,South'

Re: Multiple selection values

Wed, 27 Aug 2014 06:15:38 GMT

Hi,

To Divide those value you can use subfield function in expression

if Your V_Region Value is 'North,South'

then Subfield(V_Region,',',1) will give North

and Subfield(V_Region,',',2) will give South

then you can use to compare these to values

Re: Multiple selection values

santhosh_k_n — Wed, 27 Aug 2014 06:29:11 GMT

Hi Vivek,

This will work if i am using the variable in other object, but i am using this for selections, and the output should be as follows

1. Region filed selected is North, So, V_region = North => Sate filter should display only States related to North

2. Region filed selected is North & South, So, V_region = North,South => Sate filter should display States related to North and south

.....

Hope I am clear

Re: Multiple selection values

santhosh_k_n — Wed, 27 Aug 2014 07:39:32 GMT

please find the QVW for the same