Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am brand new to Qlik and started by importing an Excel sheet I already had prepared. For this dimension "Business" I only want to see the first three values ("Ed," "PD" and "PL") on the chart and suppress the rest. In addition if the value "School" were to show up in the results I would want to include that as well. How do I do this?
I suspect you are using a simple Sum(Value) expression. You can alter it to this;
Sum({<Business = {'Ed','PD','PL','School'}>}Value)
By using set analysis "{<Business = {'Ed','PD','PL','School'}>}" it will filter only those entries for Business.
hth,
John
hi
As John try this Sum({<Business = {'Ed','PD','PL','School'}>}Value)
read this too
Thanks for the quick replies. As I said I am brand new to Qlik so I'm not sure where these expressions should go. Here is a screenshot of the entire sheet. Thanks.
Hi
try this right side below measure tab [instead of count(ISBN13) ] write below expression there
Count({<Business = {'Ed','PD','PL','School'}>}ISBN13)
Although I don't use QlikSense the expression is correct (short your "Value" measurement "ISBN13". As Mark said enter the expression into the Expression section under Measures.
Next time post this in QlikSense forum. This forum is for QlikView.
Oops...I meant as Chanty said. When folks reply to their own messages I sometimes get confused.
cool it happens sometimes
That seems to do the trick. I had been putting the expression under dimensions! Also, thanks for the reference to the Qlik Sense forum. I will post there for any follow-ups. Thanks again for all the help.
But what if I just want to exclude one column? What expression should I use to consider everything else excluding a specific column?