Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Please read this: http://community.qlik.com/docs/DOC-2380
The most important part for you: "Please consider the following points"
Regards,
Michael
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...
sorry if I am not clear. I just would need to show how many IDs are there before DUEDATE and after DUEDATE
Thanks and can ishow the count in the table itself without making any input box selections?
Dear Amelia,
If you load your apps, you will get answer soon.
Thnx
Attachment missing
PLease find the attachment.
Thanks,
Angad
Please can anyone help me in this.
Hey,
Please find the attachment.
Hope this is helpful.
Thanks,
Angad