topic Re: Slider fix in QlikView

Slider fix

rassanbekov — Wed, 26 Jul 2017 05:22:23 GMT

Hello!

Please help to set a slider in Qlikview to show the transactions from 9:00 PM to 7:00 AM period.

I need a formula or settings step by step approach.

Input data has been included

Re: Slider fix

Muthu — Wed, 26 Jul 2017 05:45:03 GMT

Please specify clearly what is your requirement.

Go through the link to see how to set up slider in Qlikview

Slider/Calendar Object ‒ QlikView

Re: Slider fix

Anil_Babu_Samineni — Wed, 26 Jul 2017 05:46:39 GMT

May be create this in variable and select Slider object then use same variable in Data section? Meanwhile, Have a look in Help

=If(Time >= '12:00 PM' and Time <= '07:00 AM', Aggr(Time, Time))

Load Statement

LOAD Time(Time,'hh:mm TT') as Time, DayNight, Details, Account, Amount

FROM (ooxml, embedded labels, table is Sheet1);

Re: Slider fix

rassanbekov — Wed, 26 Jul 2017 05:57:40 GMT

Tried by did not work

Re: Slider fix

rassanbekov — Wed, 26 Jul 2017 05:58:50 GMT

I need to select out of input data those transactions which appeared in period from 9:00:00 PM to 7:00:00. The results should be in the form of slicer. What other clarification you need?

Re: Slider fix

Anil_Babu_Samineni — Wed, 26 Jul 2017 06:47:07 GMT

that should work as we expect, Any how check the attachment for solution

Re: Slider fix

antoniotiman — Wed, 26 Jul 2017 07:22:11 GMT

Hi Ruslan,

see Attachment.

Regards,

Antonio