Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Imagine North,East,South and West are the area and A,B,C and are the groups which are there in each of the area. What I want to do is I want to exclude B group only from the East area. Rest of the area can have all the groups. I want to do this filteration at the dimension level.
Could you please help me out!
I wrote the below code to to exclude East from the Area. I don't know what is the code I have to write to exclude B Group only in East Area
=if(Area<>'East',Area)
----------------- Data for your understanding -----------------
Area
North
East
South
West
Group
A
B
C
D
Hi,
What Haneesh suggested is the right method. Please find attached the QVW file again.
Regards,
Sajeevan
Thanks Haneesh
But could you please explain what does that code does. What does that Null() do in the if condition?
The function null() returns a null value. When the condition is satisfied (Area='East' AND Group='B'), then a null value will be returned, else the group value will be returned. So, in this case when the condition is satisfied we get a null value and the chart will suppress this null value.
Hope this explains the expression clearly.
Hi Haneesh,
Understood now!!!
If Area='East' and Group='B' then it will be Null() or else it wil display the group.
Many thanks to you and Sajeevan too.