Help with Pivot Table

Wed, 08 Jun 2016 12:58:09 GMT

Hello,

I am trying to calculate data as below to a pivot table. Basically I want to show Initial & Important, Follow up & important etc by time.

The data I have is showing as below,

What I would like to get in a Pivot table is show as below,

What I did are:

1. Set Dimension by "Year", "Quarter" and "Month" in order.

2. Created 6 expressions based on "Status", they are: "Initial Important", "Initial Less Important", "Total Initial", ...The expressions shows as below,

"Initial Important": count([Status]='Initial' and [Important]='1')

"Initial Less Important": count([Status]='Initial' and [Important]='0')

"Total Initial": if ([Status]='Initial',count([Status))

"Follow up Important": if (([Status]='Follow up' and [Important]='1')

"Follow up Less Important": if (([Status]='Follow up' and [Important]='0')

"Total Follow up": if ([Status]='Follow up',count([Status))

My problem are:

1. All data in three columns related to "Initial" are the same. The value in "Total Initial" suppose be corrected.

However, those values in "Initial Important" and "Initial Less Important" are wrong.

2. There is no value/data in any of the follow up columns, except "Total Follow up".

Can anyone let me know if my logic was wrong or the commands I created for Expressions are wrong, or dimensions have problem?

Thanks so much,

Becky

topic Help with Pivot Table in QlikView

Help with Pivot Table