Count Dim in a Pivot Table

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

A couple of newbie questions.

A data stream is averaging data with a set frequency (every day) for a number of cities. Example:

Chi, 10, 20, 30, 9, 15,

Dal: 5, 6, 9, 10,...

Hous: 4, 7, 9, 2, ...

I create a simple pivot table where the "avg()" of each date series (per city) is done. To get pivot table like this:

City	Avg(avgSample)
Chi	5
Dal	11
Hous	20

Ques 1: what is the expression for having the above pivot. I can do that but please keep this in mind for the next question, as it is cause of my challenge.

Question 2: I want to count the cities which have Avg(avgSample) less than different thresholds: 10, 20, 30, 40.

Lastly, I want to get a Pie Chart. Showing what is the percentage of cities with thresholds of Avg(avgSample) less than 10, 20, 30, 40. I can use the pie chart for drawing this but...the above two questions are show stoppers.

Thanks for your help

Re: Count Dim in a Pivot Table

sunny_talwar — Tue, 17 Apr 2018 02:22:05 GMT

How exactly is your data laid out? Can you share a cleaner sample?

topic Re: Count Dim in a Pivot Table in QlikView

Count Dim in a Pivot Table

Re: Count Dim in a Pivot Table