Filter Dimensions

[amiroh81]

Hello all,

I know what I want to do should be simple but I'm complicated performing ...: (

I have a table with Dimensions and I want to show only the rows that meet certain conditions (and only on this table).

For example I have a column of STATE and I want to show only the rows that the STATE = BLOC

How do I do this?

I tried to put conditions through the EDIT but he did not get it.

Thanks in advance

[alexandros17]

Write as dimension:

if(STATE = 'BLOC', STATE, Null())

and check the box "suppress where value is null

Let me know

[MK_QSL]

You can use in script something like below

Load *

From TableName

where STATE = 'BLOC';

or

In UI side

Use Calculated Dimension

IF(STATE = 'BLOC', STATE)

and Tick Suppress When Value is NULL

Use Whatever expression you want...

[mdmukramali]

Dear,

kindly find the attached file.

i hope it will help you.

Thanks,

Mukram.

[amiroh81]

Hi

its work,

i did it before but i didnt check the 'Suppress When Value is NULL' box.

i found anotherway,

on expression i dfined =Match( STATE ,'BLOC')

and its work also.

thank you very much everybody!

[its_anandrjs]

So you got the solution there are many ways

In load script you can filter

Load * from Location Where Match( STATE ,'BLOC');

In Expression

Sum(IF(Match( STATE ,'BLOC'), YourValue )

In Calculated Dimension

Match( STATE ,'BLOC')

Or

If( Match( STATE ,'BLOC'), STATE)

But select suppress when value null