Discussion Board for collaboration related to QlikView App Development.
my requirement is count the number of loads which are matching [Scheduled date] = [Actual Date] and [Actual Time] = [Schedule Time]
i tried like this
=count( {$<[Scheduled Date] = [Actual Date], [Scheduled Time] = [Actual Time] >} [Load])
how to get count
thank you
If you need a record based comparison:
=count( If( [Scheduled Date] = [Actual Date] and [Scheduled Time] = [Actual Time] , [Load]))
Or maybe, if LOAD is the Key for the dates, but not a primary key in your tables:
=count( {$<Load = {"=[Scheduled Date] = [Actual Date] and [Scheduled Time] = [Actual Time]"} >} [Load])
If you need a record based comparison:
=count( If( [Scheduled Date] = [Actual Date] and [Scheduled Time] = [Actual Time] , [Load]))
Or maybe, if LOAD is the Key for the dates, but not a primary key in your tables:
=count( {$<Load = {"=[Scheduled Date] = [Actual Date] and [Scheduled Time] = [Actual Time]"} >} [Load])
Hi,
fist step would be to put date and time together to one filed
[Actual Date] & [Actual Time] as ActualTimestamp
[Scheduled Date] & [Scheduled Time] as ScheduledTimestamp
Make sure that both this New Field have the same timpstamp formate.
How do you want to present this? On a row level or as a total?
Give us some exampledata.