Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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

0 Replies