Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
If you’re new to Qlik Cloud or Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
Hello Qlik Community,
I am working on a Qlik Sense app with multiple tables and relationships. I have a scenario where I need to perform calculations using a specific relationship, rather than relying on the active relationship.
In Power BI, this can be achieved using the USERELATIONSHIP function. However, I'm not sure what the equivalent approach is in Qlik Sense.
Here's my scenario:
- I have two tables, 'Test Details' and 'DimDate'.
- There's an active relationship between 'Test Details'[First Test Date] and 'DimDate'[Date].
- I want to calculate the total scores based on both the first test date and the second test date, but I need to specify the relationship explicitly for the second date.
Can anyone please guide me on how to achieve this in Qlik Sense? I'm open to any alternative methods or functions that can help me achieve this goal.
Any assistance or examples would be highly appreciated. Thank you in advance!