Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
Champion III
Champion III

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

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.

View solution in original post

12 Replies
YoussefBelloum
Champion
Champion

Hi,

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

Anonymous
Not applicable
Author

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

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

Anonymous
Not applicable
Author

It Is unchecked.

YoussefBelloum
Champion
Champion

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

Anonymous
Not applicable
Author

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

YoussefBelloum
Champion
Champion

so here it is:


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

Anonymous
Not applicable
Author

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

vinieme12
Champion III
Champion III

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

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.