Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

New Contributor

Line Chart get x value from y expression

Hi Community,

i want to use a Line Chart to get a course of the number of Sales.

The x-axis are the months of each year since the year 2000. 

The expression for y values looks like:

=SUM((Date(Date#([rentalstart],'DD.MM.YYYY'),'DD-MM-YYYY')<=Date(Date#(X_Value,'DD.MM.YYYY'),'DD-MM-YYYY')) AND (IsNull([rentalend]) OR Date(Date#([rentalend],'DD.MM.YYYY'),'DD-MM-YYYY') >= Date(Date#(X_Value,'DD.MM.YYYY'),'DD-MM-YYYY')))*-1

For the calculation on y-axis, i need the selected value on x-axis, that replaces the field X_Value in the expression.

Is there a Function or something like getCurrentXValue(), that i can call from the expression?

1 Reply

Re: Line Chart get x value from y expression