topic Re: If than based on selections in App Development

If than based on selections

cmenszak1 — Mon, 30 Mar 2020 20:00:51 GMT

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.

Re: If than based on selections

Vegar — Mon, 30 Mar 2020 20:58:07 GMT

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

Re: If than based on selections

cmenszak1 — Tue, 31 Mar 2020 20:16:05 GMT

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.

Re: If than based on selections

Vegar — Wed, 01 Apr 2020 07:59:06 GMT

Try an expression like this:

=AGGR(if( ONLY({1}DistributorName)=ONLY(DistributorName),
DistributorName,
ONLY({1}DistributorCode))
, DistributorName)

See attached QVW