Issue with some different context:

[#1]

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.

[ariel_klien]

Hi,

Maybe you need to change your data.

see the ex. i attached.

BR

Ariel

[#3]

Hi Ariel,

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

Thanks,

Goirik

[ariel_klien]

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)

BR

Ariel