Discussion Board for collaboration related to QlikView App Development.
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
Go to Solution.
Please specify clearly what is your requirement.
Go through the link to see how to set up slider in Qlikview
Slider/Calendar Object ‒ QlikView
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 Time(Time,'hh:mm TT') as Time, DayNight, Details, Account, Amount
FROM (ooxml, embedded labels, table is Sheet1);
Tried by did not work
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?
that should work as we expect, Any how check the attachment for solution