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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Price Variance Bar Chart

Dear Community

I wonder how can I build a Price Variance Bar Chart in Qlik Sense. It is to show the Percentage price variance between Current unit price and Last PO price for parts.  [ ( Current Unit price - Last PO price ) / Last PO price ] x 100%



The result I want is as follows.

(Even part no. TYU2435 ordered twice in the Jan, I want to use $2500, the Last PO price, to calculate.)


However, I don't know how to build it in Qlik sense. As I already set:

Dimensions: Part No.


Show in percent

Static max 1, min -1


How can I set the expression in Measures?

Thank you very much. Please give me a helping hand.

0 Replies