topic Select in field based on variable condition in QlikView

Select in field based on variable condition

Mon, 14 Dec 2015 18:12:46 GMT

Hi,

I want to select all the countries on button click whose GDP is greater than upper range for its region.

For example:

Select in Field: Country

Search String: =vGDP >= [Upper Range] or =$(vGDP) >= [Upper Range]

However, no countries are getting selected. Can anyone help?

Thanks,

hemhund2016 — Mon, 14 Dec 2015 18:20:08 GMT

Some thing like this will help.

Field: Country

Search String: = '("' & concat({<vGDP={'>=$(=Max(Range))'}>} Country,'" | "') & '')'

Thanks,

Hemanth.

sinanozdemir — Mon, 14 Dec 2015 18:23:33 GMT

Try the below in the search string:

='(' & Concat(If($(vGDP) >= [Upper Range], Country), '|') & ')'

Mon, 14 Dec 2015 18:31:36 GMT

Hi Sinan,

This somewhat helps but only one country is getting selected not all countries whose GDP is greater than upper range of its region.

Thanks,

sinanozdemir — Mon, 14 Dec 2015 18:39:55 GMT

What is in the variable, such Sum(), Count(), etc?

Mon, 14 Dec 2015 18:47:23 GMT

For vGDP ? Its sum.

sinanozdemir — Mon, 14 Dec 2015 18:50:08 GMT

Let's try the below:

='(' & Concat(If(Aggr($(vGDP), Country)>= [Upper Range], Country), '|') & ')'

Thanks

Mon, 14 Dec 2015 18:54:30 GMT

Perfect! Thank you so much!

sinanozdemir — Mon, 14 Dec 2015 18:55:42 GMT

You are welcome.