QlikView App Dev

[rassanbekov]

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

[Muthu]

Please specify clearly what is your requirement.

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

Slider/Calendar Object ‒ QlikView

[Anil_Babu_Samineni]

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);

[rassanbekov]

Tried by did not work

[rassanbekov]

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?

[Anil_Babu_Samineni]

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

[antoniotiman · Accepted solution]

Hi Ruslan,

see Attachment.

Regards,

Antonio