Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Please post sample qvw file along with the test data.
Hi,
Use wildmatch() inside if()
Try like
if(wildmatch(region,V_region),State,'Please Select Region')
Regards
Hi Max,
This didn't work as the multiple selected values are saved in variable as comma separate say like 'North,South'
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
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
please find the QVW for the same