Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
rassanbekov
Partner
Partner

Slider fix

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

1 Solution

Accepted Solutions
antoniotiman
Master III
Master III

Hi Ruslan,

see Attachment.

Regards,

Antonio

View solution in original post

6 Replies
Muthu
Partner
Partner

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
rassanbekov
Partner
Partner
Author

Tried by did not work

rassanbekov
Partner
Partner
Author

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
antoniotiman
Master III
Master III

Hi Ruslan,

see Attachment.

Regards,

Antonio