Showing or not showing data in either a table or graph that already has an expression under condition
Hello to All,
I apologize for the lond subject I didnt know how to write it concisely. My problem is I think simple to resolve yet it must be personal limitations that dont allow me to go further. I have a simple straight table with two columns of information. The first column has names of people, and the second column a measured level of their happiness on a scale of 1-10. I can tell QV to do an IF analysis because I only want those names with happiness >8.5 to appear, but the furthest i have gotten is all the names again but with the classification of whether they hold true or false to the condition (>8.5) How can I ask QV to show me only the values (8.5-10) for those names that fall under the previous condition.
I am first time user and I ask for your patience and understanding and would be glad to re explain or change my explanation if you folks dont understand me. And of course if that is the case I apologize in advance.
Under the dimensions tab of the properties box of the table 'Add a Calculated Dimension' and enter a expression similar to the following: =if(Happiness>=8.5,Name) and finally check the box 'Supress Where Value is Null'.
