Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I made a line chart that contains two dimensions ([Month Year] and [DATE]) and a single measure (Outstanding savings). The [DATE] is an alternative dimension. I want to display for each dimension selected in the graph the appropriate reference line.
In the expression of the reference line, I did as follows but it always shows me the same reference line (the conition in the if always returns False):
= if ([Month Year] = [Month Year],
avg (aggr (Sum ({$ <[Line Type] = {"Savings Outstanding"}, [Flag End Month] = {"1"}>} Balance), [Month Year])),
avg (aggr (Sum ({$ <[Line Type] = {"Savings Outstanding"}>} Balance), [DATE]))
)
I need to know the good condition. Thanks for your help.
Hi Marwa,
You can do this by using a condition on the expression with GetCurrentField(cyclegroupname)
When you choose one of them, it should activate the appropriate expression based on the current cyclic group dimension.
Hi Felip,
Thank you for the response. The function GetCurrentField(cyclegroupname) is not supported by Qlik sense.
Is there another solution?