How to write expression in table.

[#1]

Hi,

I have Team as dimension and I need to show the Count of IDs which are in within DUEDATE and which are above DUEDATE.

Can anyone help me with expression please?

Thanks.

[Anonymous]

Please read this: http://community.qlik.com/docs/DOC-2380

The most important part for you: "Please consider the following points"

Regards,

Michael

[giakoum]

For date range :

Count({$<[DUEDATE] = {">=$(vMinDate)<$(vMaxDate"}} [ID])

For above date :

Count({$<[DUEDATE] = {">=$(vAboveDate)"}} [ID])

but you need to define the variables (user input?). the requirement is not very clear...

[#4]

sorry if I am not clear. I just would need to show how many IDs are there before DUEDATE and after DUEDATE

[#5]

Thanks and can ishow the count in the table itself without making any input box selections?

[MK_QSL]

Dear Amelia,

If you load your apps, you will get answer soon.

Thnx

[MK_QSL]

Attachment missing

[#8]

PLease find the attachment.

Thanks,

Angad

[#9]

Please can anyone help me in this.

[#10]

Hey,

Please find the attachment.

Hope this is helpful.

Thanks,

Angad