topic Re: Issue with some different context: in QlikView

Issue with some different context:

Sun, 01 Sep 2013 10:10:15 GMT

Hi All,

I am new in Qlikview. I am facing an issue when I tried to calculate some deals in different context. Could you help me out? My requirement is something like that: I have 5 deals in month of June in 2013. Deals are created and closed by different different persons. Now I need to design a table where dimension would be Year, Month and Created by and measure value would be count of deal of created by and count of deal of closed by. The count of created by is showing fine but I can not define the count of deal for closed by.

This below is my raw data:

Header 1

Account Schedule Number	Year	Month	Created By	Closed By
10001	2013	June	Melissa	Dana
10002	2013	June	Melissa	Tammy
10003	2013	June	Melissa	Tammy
10004	2013	June	Dana	Tracy
10005	2013	June	Melissa	Regina
10006	2013	June	Melissa	Melissa

My requirement is like :

Header 1

Year	Month	Created By	Total Created #	Total Closed#
2013	June	Melissa	5	1
2013	June	Dana	1	1
2013	June	Tammy	0	2
2013	June	Tracy	0	1
2013	June	Regina	0	1
Total			6	6

Pls help me out. Thanks in advance.

Re: Issue with some different context:

ariel_klien — Sun, 01 Sep 2013 11:30:34 GMT

Hi,

Maybe you need to change your data.

see the ex. i attached.

Ariel

Re: Issue with some different context:

Sun, 01 Sep 2013 11:40:46 GMT

Hi Ariel,

I could not find your attachment. Could you pls check from your end.

Thanks,

Goirik

Re: Re: Issue with some different context:

ariel_klien — Sun, 01 Sep 2013 12:00:05 GMT

this is my output:

i made 2 new fields (person, action)

LOAD * INLINE [

Account Schedule Number, Year, Month, person, Action

10001, 2013, June, Melissa, Create

10002, 2013, June, Melissa, Create

10003, 2013, June, Melissa,Create

10004, 2013, June, Dana, Create

10005, 2013, June, Melissa, Create

10006, 2013, June, Melissa, Create

10001, 2013, June, Dana , Close

10002, 2013, June, Tammy, Close

10003, 2013, June, Tammy, Close

10004, 2013, June, Tracy, Close

10005, 2013, June, Regina, Close

10006, 2013, June, Melissa, Close

];

my expressions: Create : count({<Action={'Create'}>} person)

Close: count({<Action={'Close'}>} person)

Ariel