Using product in Expression value?

[#1]

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

[Gysbert_Wassenaar]

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

[sunilkumarqv]

hi aditi.

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

[luis_pimentel]

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

[#5]

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

[#6]

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

[sunilkumarqv]

Please find attached file and check it..

[Gysbert_Wassenaar · Accepted solution]

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.

[#9]

Hi Sunil,

I am using trial version of Qlikview.

[#10]

Thanks, its showing up now.