topic Re: How do I calculate Count Values in charts in QlikView

How do I calculate Count Values in charts

Sun, 15 Feb 2015 06:33:37 GMT

Guys need Help !!

I have created chart containing Market share of Cities in chart , and i changing cities based on slider Value( E.g greater than 80% share in Slider), by fixing the Dimension Limit .

How do I calculate count of Cities in Chart. Please Help!!!

Re: How do I calculate Count Values in charts

Anonymous — Sun, 15 Feb 2015 16:56:29 GMT

Is there reason not to simply use:

Count(Cities)

Re: How do I calculate Count Values in charts

ramasaisaksoft — Sun, 15 Feb 2015 17:27:38 GMT

Hi Ankit,

We didn't understand u r requirement exactly can send any screen shots?

any way as per my understanding check like below

Ex:-

count({$<MonthName= >} TXN_AMT )

Re: How do I calculate Count Values in charts

Tue, 17 Feb 2015 04:28:32 GMT

Hi Guys!!

As shown in image (enclosed) , i am having Market Share City Wise . I have Limited Dimension based on Slider variable Selected.

Now i want Count of Cities in a Label, which met my Condition.

Objective : Find out Count of Cities which Contribute 80%~ 20% of Sales of Region.

Please Help

Thanks@

Re: How do I calculate Count Values in charts

Wed, 20 May 2015 14:12:59 GMT

dear sir!

i have to prepare a report some thing like your images

could you please send me the sample data and qlik file

thanks

we have branch office in different cities

i have to show the cost amount of each city ....

so please it will be great if you can send me the files

thanks