topic expression construction help in QlikView

expression construction help

Anonymous — Tue, 20 Oct 2015 01:49:17 GMT

Hi,

I have 3 columns-

ID Request_date closed_date

------------------------------------------------

1 2/3/2015 3/3/2015

2 3/3/2015 3/3/2015

i want to show trending of open vs close

Open- 2nd and 3rd -1 each

closed-3rd both

i am not able to make the expression condition

so closed is depend on closed_date and open is depend on request_date

Please help

Re: expression construction help

settu_periasamy — Tue, 20 Oct 2015 02:33:20 GMT

Hi Suman,

Can you post the expected output in excel with above mentioned date?

Re: expression construction help

vincent_ardiet — Tue, 20 Oct 2015 02:42:28 GMT

Hi,

Can you give us a sample of the expected result, it's not very clear for me your part:

Open- 2nd and 3rd -1 each

closed-3rd both

Regards,

Vincent

Re: expression construction help

Anonymous — Tue, 20 Oct 2015 03:45:52 GMT

I want to show the representation on the line chart.

X axis- date

in the line- open and close count -two different line

Re: expression construction help

Anonymous — Tue, 20 Oct 2015 04:02:51 GMT

If I find the count on day 2 open case is 1 and day 3 is 1.

On 3rd closed case count is 2

All I want to show on line chart

Re: expression construction help

vincent_ardiet — Tue, 20 Oct 2015 04:06:19 GMT

I think that the cleanest way is to work a bit your datamodel.

If you can have a fact table linked to a calendar table.

In your fact table you have 2 flags for each id and date (either request or close date), flag_request and flag_close. Then you just have to sum those flags in your chart.

Regards,

Vincent