topic filter dimension in chart in QlikView

filter dimension in chart

Sat, 29 Aug 2009 00:23:55 GMT

I have a dimension field which has multiple values . I want to restrict this dimension to show only a certain value . Basically dimension is country . I want to filter the dimension to show only India. How can edit the expression to show only India without editing the SQL query behind .

Thanks

filter dimension in chart

Sat, 29 Aug 2009 00:28:27 GMT

= Sum( {$<country={India}>} Value)

filter dimension in chart

Sat, 29 Aug 2009 00:51:35 GMT

I am not creating an expression field , I needed to create a dimension but that dimension only needs to show a single value. I am looking for something like {<country={India}>} but it is not working for me. Any ideas?

filter dimension in chart

Sat, 29 Aug 2009 01:05:33 GMT

For a quick solution create a dimension when loading the script

you can use

Load

country,

if(country = 'India',country) as My_country;

SQL Select * from tblCountry;