I have a major problem and i could not solve it yet...
I have chart with calculated dimension... i want to exclude some data from a list of data in calculated dimension... actually i want to this in calculated dimension expression....
can anyone please help me on this ,,
Thanx a lot
First, read this: QlikCommunity Tip: How to get answers to your post?
In the future it will help you write your question in such a way that it elicits more responses
The technique to exclude values from a dimension largely depends on the code used in your chart, both in calculated dimension and expressions. Please post both your calculated dimension and your expressions.
assuming a chart with dimension Dim3, expression sum(...)
you can use this calculated dimension (to exclude values X and Y from dimension)
=if(match(Dim3, 'X', 'Y',), null(), Dim3)
and flag "Suppress when value is null" if you want suppress the row with null
but it depends on your chart as Peter suggests
Thanks for your kindly response...
actually the problem is from BTS Analysis Dashboard.... in this dashboard we divided BTS in 9 section ....suppose the 3*3 matrix....
Suppose i have a chart base on the segmentation like the above picture and the dim of chart must show the BTSs that are in section 1,2 and 3
so i have to use calculated dimension .suppose i need to show bts in section 1 in that case my calculated dimension is something like: if (x>=1.5 and y>=1.5,BTS)... but i dont know how can i write an expression for section 1 and 2 and 3 ....