topic Re: Data issue in Pivot table in QlikView

Data issue in Pivot table

dasaradh — Wed, 06 Jan 2016 10:47:05 GMT

i have a pivot table it having 3 countries data

like this

for denmark customers/active customers% result is correct but for sweden and denmark i am getting wrong values?

can some body help me in this

thanks in advance

thanks,

dasaradh

Anonymous — Wed, 06 Jan 2016 12:39:19 GMT

Could you share your expression??

Anonymous — Wed, 06 Jan 2016 12:42:04 GMT

Do some thing like this:

Denmark Expression:

(Count({<Country={'Denmarl'}, Flag={'Active'}>} distinct Customerid)

Count({<Country={'Denmarl'}>} distinct Customerid))*100

Similar for other countries....

dasaradh — Wed, 06 Jan 2016 13:25:40 GMT

exp is

count({$<[ActiveAcctInd]={'Y'},$(vFilterLastDay)>} distinct CustomerNbr)/ count({$<$(vFilterLastDay), LineType={Normal}>} distinct CustomerNbr)

sunny_talwar — Wed, 06 Jan 2016 13:43:50 GMT

What is the expression you are using currently?

dasaradh — Thu, 07 Jan 2016 07:06:47 GMT

hi Sunny,

count({$<[ActiveAcctInd]={'Y'},$(vFilterLastDay)>} distinct CustomerNbr)/ count({$<$(vFilterLastDay), LineType={Normal}>} distinct CustomerNbr)

this the exp i am using

pls help me in this

thanks,

dasaradh