topic Calculated Field in QlikView

Calculated Field

Thu, 26 Aug 2010 15:23:11 GMT

Hi all,

I am using QV 8.5 and I don't know how to use a calculated field (AVG) to monitor how many cases of each field value occurs using various selections criteria.

I attach a very simply example of what i am triying to do.

The pourpose is to have a table or Graph to count how many vendors have the AVG of sales in each range (1.5, 2.0, 2.5, etc.) after varying the selection criteria.

Example:

AVG(SALES) VENDORS

5.0 3

5.5 2

6.0 1

Thank you in advance,

Calculated Field

Thu, 26 Aug 2010 15:33:13 GMT

I cant download you file, but you can put a calculated dimension (AVG(SALES)) and in your expression put COUNT(VENDORS)

Calculated Field

Thu, 26 Aug 2010 15:59:37 GMT

Erico,

Thank you for your answer,

Thats what I am doing, but when you change the selection criteria (YEAR,MONTH,ETC.) The AVG(SALES) also change an the (COUNT(VENDORS) is different for each case.

Thanks,

Calculated Field

Thu, 26 Aug 2010 16:12:41 GMT

If you dont wanna change the graph, you need untached object or using a sel analisys!!!!!

Calculated Field

montubhardwaj — Thu, 26 Aug 2010 18:18:06 GMT

Because when you are changing your selections say YEAR, for 2009 , you will have diff.Sales value and also no of Vendors for that Sales than compared to YEAR 2010. So automatically the numbers will vary.

Regards,

Sharma