topic Re: slider range is not working in App Development

slider range is not working

Swathi — Fri, 15 Nov 2024 21:06:43 GMT

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.

Re: slider range is not working

Swathi — Thu, 18 Jan 2024 09:48:00 GMT

@Rohan , Kindly help to solve the issue

Re: slider range is not working

Anil_Babu_Samineni — Thu, 18 Jan 2024 10:45:56 GMT

@Swathi thanks for the QVF, try this?

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

Re: slider range is not working

Swathi — Thu, 18 Jan 2024 11:14:17 GMT

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

Re: slider range is not working

Anil_Babu_Samineni — Thu, 18 Jan 2024 11:53:09 GMT

@Swathi For me seems OK.

Re: slider range is not working

Rohan — Fri, 19 Jan 2024 11:04:49 GMT

Hi @Anil_Babu_Samineni ,

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

Regards,

Rohan.

Re: slider range is not working

Rohan — Fri, 19 Jan 2024 11:15:00 GMT

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.

Re: slider range is not working

Anil_Babu_Samineni — Sat, 20 Jan 2024 09:05:52 GMT

@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)'