Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
shaan007
Partner - Creator
Partner - Creator

Duplicate Date time values in X-axis

I am having another strange problem here.

This is a List box of Transaction Date and time.

It’s not supposed to show duplicate values.

That’s mean those two dates are not the same.

Do u have any Idea?

please see my attachment image.I made that Date and time field from


TransactionALL:

LOAD
PK_TRANSACTION,
[Trans Start DateTime],
[Trans End DateTime]
FROM
TransactionALL.qvd
(
qvd);

TransactionFlow:

load DISTINCT
PK_TRANSACTION
,
TimeStamp(Num([Trans Start DateTime])+(((IterNo()-1)/60/24)),'D/MM/YYYY h:mm:ss TT') as [TransCont DateTime]
,1
as [TransCont Count]
Resident Transaction
While (Num([Trans Start DateTime])+(((IterNo()-1)/60/24))) < (Num([Trans End DateTime]))
;


20 Replies
shaan007
Partner - Creator
Partner - Creator
Author

Thank you so much Michael, helped me

round([Trans Start DateTime]+(((IterNo()-1)/60/24)),1/1440) helped me

--------------------------------------------------------------------------------------------------------------------

TempTrans_Continuing:
NoConcatenate load
PK_TRANSACTION
,
timestamp(

     round([Trans Start DateTime]+(((IterNo()-1)/60/24)),1/1440)

     ,'D/MM/YYYY h:mm:ss TT') as [TransCont DateTime]
,1
as [TransCont Count]
Resident Transaction
While

     (Num([Trans Start DateTime])+(((IterNo()-1)/60/24)))

             <= (Num([Trans End DateTime]))
;