topic Re: Filter specific data in Connectivity & Data Prep

Filter specific data

Anonymous — Mon, 15 Jan 2018 08:39:09 GMT

Hello,

How can I filter specific data?

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

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

Re: Filter specific data

YoussefBelloum — Mon, 15 Jan 2018 08:54:28 GMT

Hi,

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

Re: Filter specific data

Anonymous — Mon, 15 Jan 2018 08:59:39 GMT

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

Re: Filter specific data

YoussefBelloum — Mon, 15 Jan 2018 09:04:29 GMT

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

Re: Filter specific data

Anonymous — Mon, 15 Jan 2018 09:07:22 GMT

It Is unchecked.

Re: Filter specific data

YoussefBelloum — Mon, 15 Jan 2018 09:09:58 GMT

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

Re: Filter specific data

Anonymous — Mon, 15 Jan 2018 09:11:53 GMT

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

Re: Filter specific data

YoussefBelloum — Mon, 15 Jan 2018 09:13:52 GMT

so here it is:

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

Re: Filter specific data

Anonymous — Mon, 15 Jan 2018 09:19:24 GMT

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

Re: Filter specific data

vinieme12 — Mon, 15 Jan 2018 09:35:13 GMT

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

Re: Filter specific data

YoussefBelloum — Mon, 15 Jan 2018 09:42:36 GMT

sachinnataraj‌ didn't you tell me that the dimension is called Customer ?

it is not the same answer i gave you here ?

Re: Filter specific data

Anonymous — Mon, 15 Jan 2018 10:00:28 GMT

Yes it is the same, but there was a " missing. I figured it out later.

Any how thanks a lot.

Sachin

Re: Filter specific data

YoussefBelloum — Mon, 15 Jan 2018 10:01:27 GMT

No problem, Good luck !