Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to change some data from excel by using QlikView.
I want to convert the left side data(c) into the right side(d) by only using qlikview. There’s the coding form from excel on the top of the pic for reference. Tks for help!!!!!!!!
seems to work for me though
table1:
Load *,
Timestamp(Floor(C,'03:00'),'YYYY/MM/DD hh:mm:ss') as D,
Timestamp(Floor(C,1/8),'YYYY/MM/DD hh:mm:ss') as D2;
Load Timestamp#(Timestamp(Now()-Rand()*10,'YYYY/MM/DD hh:mm:ss'),'YYYY/MM/DD hh:mm:ss') as C
AutoGenerate 100;
Can you share some screens of what you did and how your result looks like?
maybe
Timestamp(Floor(C,'03:00'))
or
Timestamp(Floor(C,1/8))
?
Sorry, it doesn’t work 😢btw tks for help. Appreciate!!
seems to work for me though
table1:
Load *,
Timestamp(Floor(C,'03:00'),'YYYY/MM/DD hh:mm:ss') as D,
Timestamp(Floor(C,1/8),'YYYY/MM/DD hh:mm:ss') as D2;
Load Timestamp#(Timestamp(Now()-Rand()*10,'YYYY/MM/DD hh:mm:ss'),'YYYY/MM/DD hh:mm:ss') as C
AutoGenerate 100;
Can you share some screens of what you did and how your result looks like?
Here’s the result🥲🥲
It works! Appreciate your help!!!
glad it helped.