topic Re: List Box in QlikView

List Box

NavinReddy — Mon, 31 Mar 2014 18:48:10 GMT

Dear All,

I have a list box How can i apply filters

Region list box ,How can filter(US,UK,CHINA,INDIA,SINGAPORE)

if(Wildmatch([Region],'US','UK','CHINA','INDIA','SINGAPORE'),[Region])

Im using this but im getting Other Region Values also
Please help me Some one

Thanks In Advance
Niru

Re: List Box

its_anandrjs — Mon, 31 Mar 2014 18:52:14 GMT

Use like take a list box and select Expression and type this code

if(Wildmatch([Region],'US','UK','CHINA','INDIA','SINGAPORE'),[Region])

Hope this helps

Re: List Box

MK_QSL — Mon, 31 Mar 2014 18:52:53 GMT

IF(Match(Region,'US','UK','CHINA','INDIA','SINGAPORE'), Region)

Re: List Box

its_anandrjs — Mon, 31 Mar 2014 18:54:43 GMT

You can create a field from this in load script also like

if(MixMatch([Region],'US','UK','CHINA','INDIA','SINGAPORE'),[Region]) as FilterRegion

Hope this helps

Re: List Box

NavinReddy — Mon, 31 Mar 2014 19:40:44 GMT

But again im getting other values ' - '

like symbol

Re: List Box

maxgro — Mon, 31 Mar 2014 19:45:00 GMT

like this?

Re: List Box

NavinReddy — Mon, 31 Mar 2014 19:46:32 GMT

Yes Like the way only,

when i apply filters But im getting

Other than Filter values also

Re: List Box

NavinReddy — Mon, 31 Mar 2014 19:59:15 GMT

Im using this into Dimention limit in Pivot chart

there im getting other than filters also

Re: List Box

MK_QSL — Mon, 31 Mar 2014 20:13:02 GMT

Create a pivot table

Calculated Dimension

IF(Match(Region,'US','UK','CHINA','INDIA','SINGAPORE'), Region)

Tick Suppress When Value is NULL

Expression

SUM(Sales)

Re: List Box

its_anandrjs — Mon, 31 Mar 2014 20:21:22 GMT

Take a list box and type below code in expression

=if(MixMatch([Region],'US','UK','CHINA','INDIA','SINGAPORE'),[Region])

or you can add a field in load script like

if(MixMatch([Region],'US','UK','CHINA','INDIA','SINGAPORE'),[Region]) as FilterRegion

or you can use this in any chart also

Hope this helps

Re: List Box

NavinReddy — Mon, 31 Mar 2014 20:27:12 GMT

Thank you so much

Wow Nice answer thank you