Qlik Community

Qlik Sense Data Connectivity

Discussion board where members can learn more about Qlik Sense Data Connectivity.

sachinnataraj
New Contributor II

Filter specific data

Hello,

How can I filter specific data?

I want to delete or want to show the data excluding ("All") in the graph.dsa.JPG

I have tried to set the range min/max but it didnt work.

I want the graph to show the data starting from -500 and assending order.

can you please help me out eith this.

Thank you,

Sachin

1 Solution

Accepted Solutions
vinieme12
Esteemed Contributor II

Re: Filter specific data

Exclude dimension value in your SetAnalysis


((Sum({$<[Year]={2017} , [CustomerName]-={'All'}>}[Gross Margin Actual Year]))

- (Sum({$<[Year]={"2016"},, [CustomerName]-={'All'}>}[Gross Margin Actual Year])))


Set Analysis: syntaxes, examples

12 Replies
YoussefBelloum
Esteemed Contributor

Re: Filter specific data

Hi,

can you add more details ? the dimension, the expression.. the qvf file ?

sachinnataraj
New Contributor II

Re: Filter specific data

Hello,

I am sorry, cannot add qvf file.

The dimensions are Customer name and Gross margin


And the expression in gross margin is

((Sum({$<[Year]={"2017"}>}[Gross Margin Actual Year])) - (Sum({$<[Year]={"2016"}>}[Gross Margin Actual Year])))

Regards,

Sachin

YoussefBelloum
Esteemed Contributor

Re: Filter specific data

Try to uncheck "include null values" on the dimension parameters

Highlighted
sachinnataraj
New Contributor II

Re: Filter specific data

It Is unchecked.

YoussefBelloum
Esteemed Contributor

Re: Filter specific data

so you have a value called "All" in your dimension field ?

sachinnataraj
New Contributor II

Re: Filter specific data

Yes & I want to exclude only that value in the graph and show the remaininng values.

YoussefBelloum
Esteemed Contributor

Re: Filter specific data

so here it is:


((Sum({$<[Year]={"2017"},Customer-={'All'}>}[Gross Margin Actual Year])) - (Sum({$<[Year]={"2016"},Customer-={'All'}>}[Gross Margin Actual Year])))

sachinnataraj
New Contributor II

Re: Filter specific data

No this does not works. It still gives me the value "All"

vinieme12
Esteemed Contributor II

Re: Filter specific data

Exclude dimension value in your SetAnalysis


((Sum({$<[Year]={2017} , [CustomerName]-={'All'}>}[Gross Margin Actual Year]))

- (Sum({$<[Year]={"2016"},, [CustomerName]-={'All'}>}[Gross Margin Actual Year])))


Set Analysis: syntaxes, examples

Community Browser