Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
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
Honored Contributor III

Re: Slider fix

Hi Ruslan,

see Attachment.

Regards,

Antonio

6 Replies
Partner
Partner

Re: Slider fix

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

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

Re: Slider fix

Tried by did not work

Partner
Partner

Re: Slider fix

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

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
Honored Contributor III

Re: Slider fix

Hi Ruslan,

see Attachment.

Regards,

Antonio