Hi All. I am very new to Qlikview. I got a requirement which seems to be very different to me. Hope you guys can throw some light on this.
I have three measures for examples Product, Sales and Campaign. And we have three different date field for all the three. They are Product_Expiration_Date, Sales_Date and Campaign_Date. Also we have derived three different Year Quarter for these.
Now I want to create a Line chart with all the three measures for FY17Q4, FY18Q1, FY18Q2, FY18Q3, FY18Q4. However how can I combine all the FYQ's (Product_Expiration_Date, Sales_Date and Campaign_Date) so that I can use a conman dimension?