Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Need Help for an Intersection Problem in Set Analysis

Hi at all,

i have a problem with an intersection in Set Analysis.

I have one Table with Parts, Prices and Factorys.

I need the difference beetween the Prices in two different Factories for the Same Part.

How is the correct Expression with Aggr in a Text Field?

Details in the Example (.qvw) 

10 Replies
miikkaqlick
Partner - Creator II
Partner - Creator II

Hi!

Here is a solution for you:

Diff:

Sum({$<Factory = {'200'}, Part = P({<Factory= {'100'}> }) *    P({<Factory= {'200'}>}) >} Price)

-

Sum({$<Factory = {'100'}, Part = P({<Factory= {'100'}> }) *    P({<Factory= {'200'}>}) >} Price)

Br,

Miikka Koskinen