topic help with expression in QlikView

help with expression

Tue, 26 Feb 2013 14:34:31 GMT

Hi All,

I have the following expression and i need to add something to it but struggling to get it working.

the current expression is

count({$<[Source]= {"EX"}>}distinct [Allocation Legacy Key])

I want to add a condition so that it only counts the lines where :

[Sent for Payment Date]-[Transaction Date]>60

Can anyone help me with adding this into the expression?

Many thanks

Gysbert_Wassenaar — Tue, 26 Feb 2013 14:39:13 GMT

Something like this maybe:

count({$<[Source]= {"EX"},[Allocation Legacy Key] ={"=[Sent for Payment Date]-[Transaction Date]>60"} >}distinct [Allocation Legacy Key])

Tue, 26 Feb 2013 14:41:02 GMT

Nice one Gysbert! works a treat!

Thanks