Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Maximize ROI with Qlik Professional Services – Expert Guidance, Faster Results: Explore Qlik Services
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Using product in Expression value?

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

1 Solution

Accepted Solutions
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

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.


talk is cheap, supply exceeds demand

View solution in original post

10 Replies
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

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


talk is cheap, supply exceeds demand
sunilkumarqv
Specialist II
Specialist II

hi aditi.

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

luis_pimentel
Partner - Creator III
Partner - Creator III

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

Not applicable
Author

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

Not applicable
Author

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

sunilkumarqv
Specialist II
Specialist II

Please find attached file and check it..

Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

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.


talk is cheap, supply exceeds demand
Not applicable
Author

Hi Sunil,

I am using trial version of Qlikview.

Not applicable
Author

Thanks, its showing up now.