Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
How can i make it, that if i select a "Year", that the first linechart "Sales" get the year "salesYear" and the second linechart "Price" get "priceYear"?
regards,
Fritz
Hi Fritz, would it make sense to create "Year" field in "Sales" and "Price" tables based on "SalesYear" and "PriceYear" respectively? That way the tables will be connected by "Year", and you still can display "SalesYear" and "PriceYear".
It works in Qlik Sense too:
I add the field year in the expression of the calculated dimension YEAR : = If(Year = salesYear and Year = priceYear and Year = Year, Year)
When I select 2015 in the calculated dimension, The three other take automaticly the same value:
But I agree with other, that it would be better to use only one field Year in your model. If it's not possible you have this solution
Hi Sébastien,
thank you very much, this solution help me for my problem.
regards,
Fritz