Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Write as dimension:
if(STATE = 'BLOC', STATE, Null())
and check the box "suppress where value is null
Let me know
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...
Dear,
kindly find the attached file.
i hope it will help you.
Thanks,
Mukram.
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!
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