topic Re: Acceptable 30 days Slider in QlikView

Acceptable 30 days Slider

krishnakv83 — Wed, 25 Nov 2020 16:16:04 GMT

Hi Experts,

I have table of information received date, planned date,Avg difference and % diff.All metrics are parametarised in the script and coming as variables to UI.Now I want to create two sliders one for Acceptable 30 days(difference of received date, planned date) and % Diff slider.Based on the slider the table metrics should reflect.Please show some light on this.

Regards, Venkat Krishna

Re: Acceptable 30 days Slider

RonaldDoes — Fri, 13 Oct 2017 14:40:48 GMT

Hi Venkat,

Can you share your app here?

Re: Acceptable 30 days Slider

Anil_Babu_Samineni — Fri, 13 Oct 2017 15:10:49 GMT

May be like this and then use FieldName as Slider

If([Received Date] - [Planned Date] <= 30, Dimension) as FieldName

Re: Acceptable 30 days Slider

krishnakv83 — Fri, 13 Oct 2017 15:40:06 GMT

Hi Anil,

you want me to create variable in script and use in the slider?

Regards,

venkat

Re: Acceptable 30 days Slider

Anil_Babu_Samineni — Fri, 13 Oct 2017 15:42:49 GMT

Not sure, Why are you going in variable. Even, you can create field and then call that field into slider object if not necessary as variable

Re: Acceptable 30 days Slider

MarcoWedel — Fri, 13 Oct 2017 18:45:43 GMT

I guess you mean field instead of variable?

Re: Acceptable 30 days Slider

krishnakv83 — Mon, 16 Oct 2017 10:29:12 GMT

Thank you for quick reply

Yes variable.

For recieved date, Based on the order type I use received date or confirmed date to find the 30 days difference.As let variable already created in the script I want to create variable in the UI layer to show in the table.Is it possible to do it. Because I'm facing #NA error when using the variable in the slider.

Regards,Venkat

Re: Acceptable 30 days Slider

MarcoWedel — Mon, 16 Oct 2017 20:05:16 GMT

please post a sample application including some sample data and your variable and describe your expected result.

thanks

regards

Marco