slider range is not working

[Swathi]

for range of selection, i nave created two slider one for min and one max selection, based on the selection on sliders, my delv_qty should filter. without changing existing formulas, i have given one button added action there. but it is filter the data.

=Concat(distinct {<delv_qty={">=$(=vgrowth)<=$(=(vbut2))"}>} delv_qty, ';')

when i gave only one slider, and given below formula button action, it is filtering the data.

=Concat(distinct {<delv_qty={">=$(vValue)"}>} delv_qty, ';')

both are similar , but range of selection button formula is not working. kindly help me to resolve. i have attached sample sheet.

[Swathi]

@Rohan , Kindly help to solve the issue

[Anil_Babu_Samineni]

@Swathi thanks for the QVF, try this?

sum({<sold_to_desc={"=Sum(delv_qty)>=$(vgrowth) and Sum(delv_qty)<=$(vbut2)"}>} delv_qty)

[Swathi]

@Anil_Babu_Samineni , it is working Anil. it applying in the expression, not filtering the data

[Anil_Babu_Samineni]

@Swathi For me seems OK.

[Rohan]

Hi @Anil_Babu_Samineni , 

Have you added a different expression for the label of the Measure for understanding purpose or something ?

Regards,

Rohan.

[Rohan]

Hi @Swathi ,

Are you looking for something like this ? Please refer the attached qvf. I have added the following expression in the dimension for Sold_to_desc :

=if(aggr(sum(delv_qty),sold_to_desc)>=$(vgrowth) and aggr(sum(delv_qty),sold_to_desc)<=$(vbut2),
sold_to_desc,
null())

Regards,

Rohan.

[Anil_Babu_Samineni]

@Rohan The same expression to see the result in label. I used this.

='sum({<sold_to_desc={"=Sum(delv_qty)>=$(vgrowth) and Sum(delv_qty)<=$(vbut2)"}>} delv_qty)'