Skip to main content
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
Showing results for 
Search instead for 
Did you mean: 
Partner - Contributor III
Partner - Contributor III

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.


and Sum({<DistributorName=p(Distributor_A)>}CM_Sales)>sum({<DistributorName=p(Distributor_A)>}LM_Sales),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