topic Re: Using product in Expression value? in QlikView

Using product in Expression value?

Fri, 20 Nov 2020 18:02:30 GMT

Hi all,

I want to make a bar chart with dimensions Market and (Sales Value * Quantity )=Total Sales/

So, for second dimension , what do i mention in expression value.

:Aditi

Re: Using product in Expression value?

Gysbert_Wassenaar — Fri, 07 Feb 2014 12:59:46 GMT

Use Market as dimension and as expression sum([Sales Value] * Quantity)

Re: Using product in Expression value?

sunilkumarqv — Fri, 07 Feb 2014 13:01:21 GMT

hi aditi.

make Sum(Value) copy and paste this into you expression.

Re: Using product in Expression value?

luis_pimentel — Fri, 07 Feb 2014 13:04:13 GMT

You just need one dimension ( Market ) and one expression ( sum([Sales Value] * Quantity) )

Re: Using product in Expression value?

Fri, 07 Feb 2014 13:04:28 GMT

I took definition as sum([Indirect Sales Value] * [[Indirect Sales Units]) , but chart shows no data to display

Re: Using product in Expression value?

Fri, 07 Feb 2014 13:18:40 GMT

I have taken the same Luis. Kindly check attached sna[pshot

Re: Using product in Expression value?

sunilkumarqv — Fri, 07 Feb 2014 13:20:09 GMT

Please find attached file and check it..

Re: Using product in Expression value?

Gysbert_Wassenaar — Fri, 07 Feb 2014 13:21:23 GMT

Put square brackets around Indirect Sales Units: [Indirect Sales Units]

Perhaps it's easier if you select the field in the Field drop down box below and use the Paste button to insert it into your expression. That will make sure the brackets are added automatically and the name of the field won't be misspelled.

Re: Using product in Expression value?

Fri, 07 Feb 2014 13:21:26 GMT

Hi Sunil,

I am using trial version of Qlikview.

Re: Using product in Expression value?

Fri, 07 Feb 2014 13:22:52 GMT

Thanks, its showing up now.

Re: Re: Using product in Expression value?

sunilkumarqv — Fri, 07 Feb 2014 13:23:27 GMT

You can do this in manner find attached file and check.