topic Re: Re: How to write expression in table. in QlikView

How to write expression in table.

Mon, 03 Feb 2014 14:53:50 GMT

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.

Re: How to write expression in table.

Anonymous — Mon, 03 Feb 2014 14:58:15 GMT

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

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

Regards,

Michael

Re: How to write expression in table.

giakoum — Mon, 03 Feb 2014 15:00:42 GMT

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...

Re: How to write expression in table.

Mon, 03 Feb 2014 15:01:22 GMT

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

Re: How to write expression in table.

Mon, 03 Feb 2014 15:06:41 GMT

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

Re: How to write expression in table.

MK_QSL — Mon, 03 Feb 2014 15:32:57 GMT

Dear Amelia,

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

Thnx

Re: How to write expression in table.

MK_QSL — Mon, 03 Feb 2014 15:40:36 GMT

Attachment missing

Re: Re: How to write expression in table.

Mon, 03 Feb 2014 17:03:15 GMT

PLease find the attachment.

Thanks,

Angad

Re: How to write expression in table.

Tue, 04 Feb 2014 16:26:36 GMT

Please can anyone help me in this.

Re: Re: How to write expression in table.

Wed, 05 Feb 2014 06:13:07 GMT

Hey,

Please find the attachment.

Hope this is helpful.

Thanks,

Angad

Re: How to write expression in table.

Wed, 05 Feb 2014 10:49:33 GMT

Thanks for your help. The figures are showing values that are without blanks from DueDate. i,e the Total Open is 6006 intsead of 4566. I need to show the values including DueDate with Blanks. Could you please let me know how can I those and also I have to show

Closedwithinduedate+Breachedduedate should equal to count of Closed and the closed also I need to show DueDate with Blanks

Thanks in advance.

Re: Re: How to write expression in table.

Wed, 05 Feb 2014 11:54:18 GMT

Hey Amelia,

For the version you attached to me, it shows Open count at 5041. May be if QVD's will be refreshed with latest data then you can get the nunmbers matched with database.

For now, please see the attachment.

Let me know, if any other issues

--Angad

Re: How to write expression in table.

Wed, 05 Feb 2014 12:29:53 GMT

Thanks very much! I mean it. Really great work.

Could you please let me know as I have one issue to get sum of values in one straight table.

I have to show SUM(AssetValue) where AssetValue<>'To Be Confirmed','N/A','Unknown'

Please could you tell me how can I do this. I did to show the count(Assetvalue) but now I have to show the SUM(AssetValue) as another column.

Re: How to write expression in table.

Wed, 05 Feb 2014 12:53:27 GMT

Can you try using:

sum(distinct AssetValue)

Or can you create a new thread, so that new members can also help in this.