Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a Qlik Sense app where I have dimensions for distributor name and distributor code plus one measure for sales. I am trying to create a table that shows sales data using the distributor name when it is selected in the distributor name filter box or distributor code for the distributor names not selected. I am using set analysis to show sales for all distributors regardless of the distributor name selections. I need this to work if one or multiple distributor names are selected.
Try an expression like this:
=AGGR(if( ONLY({1}DistributorName)=ONLY(DistributorName),
DistributorName,
ONLY({1}DistributorCode))
, DistributorName)
See attached QVW
I found it hard to pinpoint the core of your problem. Do you think you could post a sample of what you are trying to do? It should be easier to help you if you do so.
-Vegar
I attached a sample Qlikview app.
There is a chart in the app that I want to show the DistributorName for all selected in the DistributorName list box and the DistributorCode if the DistributorName is not selected.
Try an expression like this:
=AGGR(if( ONLY({1}DistributorName)=ONLY(DistributorName),
DistributorName,
ONLY({1}DistributorCode))
, DistributorName)
See attached QVW