-
Re: Filter specific data
youssef belloum Jan 15, 2018 3:54 AM (in response to Sachin Nataraj)Hi,
can you add more details ? the dimension, the expression.. the qvf file ?
-
Re: Filter specific data
Sachin Nataraj Jan 15, 2018 3:59 AM (in response to youssef belloum)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
youssef belloum Jan 15, 2018 4:04 AM (in response to Sachin Nataraj)Try to uncheck "include null values" on the dimension parameters
-
Re: Filter specific data
Sachin Nataraj Jan 15, 2018 4:07 AM (in response to youssef belloum)It Is unchecked.
-
Re: Filter specific data
youssef belloum Jan 15, 2018 4:09 AM (in response to Sachin Nataraj)so you have a value called "All" in your dimension field ?
-
Re: Filter specific data
Sachin Nataraj Jan 15, 2018 4:11 AM (in response to youssef belloum)Yes & I want to exclude only that value in the graph and show the remaininng values.
-
Re: Filter specific data
youssef belloum Jan 15, 2018 4:13 AM (in response to Sachin Nataraj)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
Sachin Nataraj Jan 15, 2018 4:19 AM (in response to youssef belloum)No this does not works. It still gives me the value "All"
-
-
-
-
-
-
-
-
Re: Filter specific data
Vineeth Pujari Jan 15, 2018 4:35 AM (in response to Sachin Nataraj)Exclude dimension value in your SetAnalysis
((Sum({$<[Year]={2017} , [CustomerName]-={'All'}>}[Gross Margin Actual Year]))
- (Sum({$<[Year]={"2016"},, [CustomerName]-={'All'}>}[Gross Margin Actual Year])))
-
Re: Filter specific data
youssef belloum Jan 15, 2018 4:42 AM (in response to Vineeth Pujari)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
Sachin Nataraj Jan 15, 2018 5:00 AM (in response to youssef belloum)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
youssef belloum Jan 15, 2018 5:01 AM (in response to Sachin Nataraj)No problem, Good luck !
-
-
-