Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
This may be a simple question since I'm relatively new at Qlik Sense.
My question is whether you can set-up a static condition of filter for a bar or combo chart. For example I created a simple chart that sums sales and shows them by month. I have a separate data field which contains sales type. Is it possible to set up a condition in the Expression so that my chart only shows sale of a unique sales type?
I know I could setup a separate filter pane but was looking for an alternate approach.
Hi Bruce,
Its possible in Qlikview
Sum({<saletype={"whatever"}>}sales)
Hi Bruce,
As Joshua mentioned, it is possible in QlikView as well as QlikSense.
Use the Expression mentioned above
Regards,
Rohan
Would you be able to share a sample with expected output to know exactly what you are looking to do?
Thanks for the reply but it doesn't seem to work. Here is the actual expression I am trying:
Sum({[Account Number]={"4210 Revenue : Sell-through Revenues"}>}[Commission Margin])
Unfortunately it returns no bars on the chart. What I am trying to accomplish is to display a bar chart that sums commission margin by month for only those orders that are sell-through revenues.
I think you missed this -> '<'
Sum({<[Account Number] = {"4210 Revenue : Sell-through Revenues"}>} [Commission Margin])