topic Re: Exclude data from a list in QlikView

Exclude data from a list

Sun, 09 Mar 2014 04:56:05 GMT

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

Regards

Sahar

Re: Exclude data from a list

Sun, 09 Mar 2014 05:25:35 GMT

If anyone can give me a solution to add a list of data to another list and show them in calculated dimension, my problem will be solved...

Regards,

Sahar

Re: Exclude data from a list

amit_saini — Sun, 09 Mar 2014 07:49:04 GMT

Hi Sahar,

You can use this:

where Field <> exclude_Part

Thanks,

Re: Exclude data from a list

Peter_Cammaert — Sun, 09 Mar 2014 10:05:14 GMT

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.

Re: Exclude data from a list

Sun, 09 Mar 2014 10:16:47 GMT

Hi Amit

Thank you very much for your quickly response ...

how can i use <> in calculation Dimension... can you please enplane more detail...

Regards

Sahar

Re: Exclude data from a list

maxgro — Sun, 09 Mar 2014 10:18:11 GMT

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

Re: Exclude data from a list

Sun, 09 Mar 2014 12:33:14 GMT

Hi peter

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 ....

Regards

Sahar