topic Re: NEED help with Dimension Problem in QlikView

NEED help with Dimension Problem

Thu, 22 May 2014 06:26:03 GMT

i have got a field called Paymode in this its shown that how a person has paid the amount for example CC, DD, CQ

CC stands for cash payment

DD stands for Demand draft Payment

and CQ stands for Cheque Payment

For example

HolderID paymode AMOUNT

112 CC 10000

113 DD 40000

114 CQ 60000

114 DD 10000

114 CC 60000

115 CC 10000

115 DD 20000

116 CQ 30000

116 DD 40000

117 CC 30000

117 CQ 50000

Now i want to show a analysis on how many people have paid through CC,DD,CQ

so its counting 114 in all the three CC DD and CQ

I have used expression count(distinct(HolderID )) with dimension paymode

its showing CC- 4

DD- 4

CQ- 3

In BAR CHART I AM GETTING

I want my analysis like this

CC,DD,CQ- 1

CC - 1

DD - 1

CC,DD - 1

CC,CQ - 1

DD,CQ - 1

Re: NEED help with Dimension Problem

Thu, 22 May 2014 06:32:01 GMT

In BAR CHART I AM GETTING

CC- 4

DD- 4

CQ- 4

I want my analysis like this

CC,DD,CQ- 1

CC - 1

DD - 1

CC,DD - 1

CC,CQ - 1

DD,CQ - 1

Can i do it like this ? if yes How??

Please Help

Re: NEED help with Dimension Problem

sujeetsingh — Thu, 22 May 2014 06:39:53 GMT

simple man just write down flags and Group By HolderID

===if(paymode='CC' and paymode='DD' and paymode='CQ','CC,DD,CQ') as CCDDCQFlag

some thing like this

Re: Re: NEED help with Dimension Problem

anbu1984 — Thu, 22 May 2014 06:39:59 GMT

Try this

Re: Re: NEED help with Dimension Problem

tresB — Thu, 22 May 2014 06:42:44 GMT

See the attachment.

Re: NEED help with Dimension Problem

sujeetsingh — Thu, 22 May 2014 06:53:45 GMT

Here is my concept in sample nice anbu