List Box

[NavinReddy]

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

[its_anandrjs]

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

[MK_QSL]

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

[its_anandrjs]

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

[NavinReddy]

But again im getting other values ' - '

like symbol

[maxgro]

like this?

[NavinReddy]

Yes Like the way only,

when i apply filters But im getting

Other than Filter values also

[NavinReddy]

Im using this into Dimention limit in Pivot chart

there im getting other than filters also

[MK_QSL · Accepted solution]

Create a pivot table

Calculated Dimension

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

Tick Suppress When Value is NULL

Expression

SUM(Sales)

[its_anandrjs]

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