topic Re: Need help ??? in QlikView

Need help ???

veeranj — Fri, 20 Nov 2020 18:02:30 GMT

Hi Group,

I have table like position_id and its creation_date and its closed date and status(closed or open)

Now i want to calculate based on months how many positions are opened and how many positions are closed.

As here i am having two dates,can i have a common(single) date and based on that dimension,i want to find no.of posiitons opened and closed.??

Thanks,

Anjee

sujeetsingh — Thu, 08 May 2014 04:21:04 GMT

How to use a common date.

One option i can suggest is that you can use Min(Creation_Date) and Max(Closed_Date) and create a master calender.

mangalsk — Thu, 08 May 2014 10:37:07 GMT

Hello,

You can do it using concept of master calender

jagan — Thu, 08 May 2014 10:49:13 GMT

Hi,

Attach some smaple data and file.

Regards,

jagan.

MarcoWedel — Thu, 08 May 2014 10:57:08 GMT

you can crosstable load the table to get the date and event type (opened / closed) as two different fields.

Selecting in a month(date)-Listbox would select both kinds of events (better create a seperate month field during load)

You could create two expressions like

count({$<event_type={'opened'}>} date)

and

count({$<event_type={'closed'}>} date)

to count the opened and closed positions per dimension value (e.g. month).

hope this helps

regards

Marco