Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Partner
Partner

Exception Report with Slider Range selection Selection Restriction in Alternate Dimension

Hi Gurus,

I want to create a exception report ,

below are the following conditions to be considered,

1.I will use slider for sales range selection

2. I should display the Distributor name whose Current Month Sales is less Than Last Month sales

and also it should be between Slider range selected.

3.I have Used Alternate State Distributor_A

Dimension:To Display Distributor Name, i have used the below expression.

aggr(if(sum({<DistributorName=p(Distributor_A)>}Sales)>(SliderRange)

and Sum({<DistributorName=p(Distributor_A)>}CM_Sales)>sum({<DistributorName=p(Distributor_A)>}LM_Sales),DistributorName),

DistributorName)

But the selections are still not restricted,with respect to Distributor Name(if i select Distributor Name the values should not change).

the values should change only when Distributor_A is selected.

Please help me on this.

Thanks and Regards

Suhasini G. Metri