topic Amount for specific product. how to achieve the same using specified gauge in QlikView

Amount for specific product. how to achieve the same using specified gauge

Mon, 28 Oct 2013 14:34:00 GMT

Hi All,

I have a requirement to display Amount for specific product. how to achieve the same with below specified gauge type?

tried with select field under action--> field name (product)--> and under value I gave specific product name. But am getting wrong result.

Regards,

Prajna

Re: Amount for specific product. how to achieve the same using specified gauge

Anonymous — Mon, 28 Oct 2013 14:50:13 GMT

Pajna

I presume you have created a Chart of type 'Gauge Chart'

Ignore the Actions tab.

Instead go the Dimensions tab and from the pick list on the left add the required dimension to Used Dimensions on the right.

Then go to your Expressions tab and add whatever expressions you need, something like:

avg(Amount)

Best Regards, Bill

Re: Amount for specific product. how to achieve the same using specified gauge

Gysbert_Wassenaar — Mon, 28 Oct 2013 15:17:38 GMT

Try something like sum({<Product={'Airbus'}>}Amount) as expression. Replace Product with the name of your product dimension, Airbus with the specific product name and replace Amount with the name of your amount field.

Re: Amount for specific product. how to achieve the same using specified gauge

Tue, 29 Oct 2013 06:43:34 GMT

Thanks for the help

Regards,

Prajna