Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
danielnevitt
Creator
Creator

If variables in expressions

Hi,

I have a line graph where Dimensions is CONTRACT_DT and the Expressions are min(PRICE1_USD_MT) and max(PRICE1_USD_MT).

The data source has four different commodities; HSSR, LSSR, VGO and M40.

It would be much appreciated if somone could help me write the expression to show the min and max daily price for each of the different commodites.

Regards,

Daniel

2 Replies
SunilChauhan
Champion
Champion

CONTRACT_DT , ComoditiesfieldName,Datefield in dimension

and in expression

min(PRICE1_USD_MT) and max(PRICE1_USD_MT).

hope this helps

Sunil Chauhan
danielnevitt
Creator
Creator
Author

Thank you for your reply.

I have now have dimensions as:

CONTRACT_DT

CMDTY_CD

When I add the expression min(PRICE1_USD_MT) and max(PRICE1_USD_MT) it doesn't populate the graph correctly though.

Is there something I am missing?

Regards,

Daniel