Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
Im fairly new to Qlikview and needed some help on the syntax for the following expression definition.
This is what I am trying to achive:
Sum of
Amountfield
Divided by
Number of days between Datefield1 & Datefield2
Multiplied by
Number of days between Datefield1 and the current system date.
AmountField / (DateField1 - Datefield2) x (Datefield1 - systemdate)
Any advise would great!
Thanks
How the expression will look depends on your data, most important your datefield format.
I would suggest to make seperate expressions first.
so :
Expr1 = Sum(AmountField)
Expr2 = (DateField1 - DateField2)
Expr3 = (DateField1 - systemdate)
And then see whiche will work and which not.
Depending on the format of your date field you should convert them to a number field to make it easier to calculate with.
fe num(DateField1)
PS For systemdate you could use:
Today(2)
Cheers Dennis Ill give this another shot and see how I get along!