Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Meret
Partner - Contributor II
Partner - Contributor II

Expression to compare target and measure (dimensions not connected)

Hi,

I am trying to create an expression that calculates a measure depending on criteria defined by the target. The goal is a table that shows all the targets with its measures to check if there are any violations.

The data model consists of two tables connected with an ID and the date as the key. Both tables use the same dimensions and codes, but those fields cannot be connected (because of a consequential multiplication of the data).

Here a simplified example of the problem:

Qlik Community1.png

 

The following formula works fine, if an ID is selected:

sum(if($(='['&$(vField)&']')= CODE, MEASURE))

vField = FIELD

Qlik Community2.png

 

However, the goal is to show all the IDs in the same table without a selection (therefore, set analysis is not an option).

How does the formula need to be changed to acchieve this?

Thank you very much for your help.

Labels (3)
0 Replies