topic Re: Pivot Table count Issue in QlikView

Pivot Table count Issue

sreenivas — Mon, 25 Feb 2013 08:59:28 GMT

I am facing the issue to get Count of the Values in the Pivot Table

sujeetsingh — Mon, 25 Feb 2013 09:11:24 GMT

Please explain the functionality.

vivientexier — Mon, 25 Feb 2013 09:13:40 GMT

Use an expression not a dimension.

sreenivas — Mon, 25 Feb 2013 09:18:15 GMT

To get the Total Count of Values Based on the Month

Mon, 25 Feb 2013 09:18:53 GMT

Hi Srinivas,

Are you looking for the count of the contracts and id's coming multiple times across the Month?

er_mohit — Mon, 25 Feb 2013 09:21:15 GMT

hiii try this

i didnt open your file because i used personal edition but how if i get you properly then see the attached file.

hope it helps

sujeetsingh — Mon, 25 Feb 2013 09:32:32 GMT

Try this sample.

sreenivas — Mon, 25 Feb 2013 09:40:21 GMT

Count of Values i can get directly ,

but using Pivot o Month some values will be null So I need to get the Count of available values

sreenivas — Mon, 25 Feb 2013 09:41:58 GMT

Actuall i need the Count of Values Present in the Months

sreenivas — Mon, 25 Feb 2013 09:45:29 GMT

See in the attached image the wrong value is highlighted Instead of getting Result 2 i got 1

sujeetsingh — Mon, 25 Feb 2013 09:52:38 GMT

Srinivas i am unable to get what you are saying.Sorry for that.

Please explain in simple words and amount of words.

sreenivas — Mon, 25 Feb 2013 10:00:21 GMT

Contract	ID	Count	Nov	Dec
AAA	1	2	1.5	2
BBB	2	1	-	1.6667

See in that pivot Table I have Values By Month wise

I need The Total Count of Values for Nov and Dec Month Together .

Required Out Put as Above Table.

sujeetsingh — Mon, 25 Feb 2013 10:09:12 GMT

See this now ...may it help you.