Discussion board where members can get started with Qlik Sense.
i want date differences. i have date as TranDateNum... i am calculating like TranDateNum-above(TranDateNum) but i failed to get the result
can please help what is the best expression here.
are you sure you have only one TranDateNum value for dimensions ?
give a try with below:
TranDateNum - Above( Only(TranDateNum) )
i am sure there is only one TranDateNum .
TranDateNum - Above( Only( TranDateNum) ) ---> let me try with this.
thanks for your replay
Try this as well might be it should worked
=TranDateNum - DATE( Above(TranDateNum) )
=INTERVAL( TranDateNum - DATE(Above(TranDateNum) ) ,'DD')
i have a doubt TranDateNum in in Number format if i use DATE(Above(TranDateNum)) it will convert into date format.
how can i subtract num with date.
Ohh then convert first it into date format may help you change into your desired date format.
=Date(TranDateNum) - DATE( Above(TranDateNum) )
=INTERVAL( Date(TranDateNum) - DATE(Above(TranDateNum) ) ,'DD')
in above picture Trandate is already in date format
in the above i am not able to get values for Above(TranDatenum)
try change the expression in Above(TranDatenum) to see what you get for the first two rows.
for Above(TranDatenum) i am not getting any values.
i am not getting what is the problem . can you suggest me any solution.
Then why you write previous "TranDateNum in in Number format" please check format once.