Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
reinholdgraf
Creator
Creator

Set-Analysis,

Hi.

I have the following data:

  • key-figure (hierarchical: e.g. P&L-Figures, Sales, Sales-Domestic)
  • regions (hierarchical: e.gl. EU-Germany-state)

I want to show 2 charts:

  • selected key-figure for selected region, month by month
  • sales (specific key-figure) for selected region, month by month

First chart - no problem

Second chart: Must use selected region but not selected key-figure (use "sales" instead).

To solve this problem, I tried to use SetExpressions.

Unfortunately, I am new to QS and don't have the time to spend hours on trial and error.

I was looking on Fabrice Aunez's manual "The Sets Analysis",

Set Analysis: syntaxes, examples

which is excellent but for a non-programmer and newbie hard to understand...

Any idea to this will  be appreciated.

Reinhold

1 Solution

Accepted Solutions
simenkg
Specialist
Specialist

How about:

sum({<[Key-Figure]={Sales}>} Amount)

View solution in original post

6 Replies
Anonymous
Not applicable

Hello,

Can you share what you have done so far? (the qvf file)

BR

Serhan

reinholdgraf
Creator
Creator
Author

yes (attachement in the original post)

bar chart - ok

line diagramm - ?? (this one should only show "sales" in selected Region/Periode).

simenkg
Specialist
Specialist

How about:

sum({<[Key-Figure]={Sales}>} Amount)

reinholdgraf
Creator
Creator
Author

works, as long as the selected key-figure is on the same or higher level.

e.g. if "P&L" is selected, it works, because "Sales" is a subset thereof.

if "Receivables" is selected, the line-chart shows no values, because "Sales" is no subset of "Receivables"...

I think, this has to do with the hierarchy used.

Anonymous
Not applicable

Hello Reinhold,

I would like to do it myself but my basic level German is not sufficient for it.

I believe your Key-Figure dimension is Kennzahl. If you try Simen's solution, it should work.

BR

Serhan

reinholdgraf
Creator
Creator
Author

yes - it works.

But you always have to set all hierarchy-levels to get the correct values. (like follows as example):

sum({<HS1=, HS2=, HS3={"01.1. Bruttoumsatz"}, HS4=, HS5=, Kennzahl= >} Wert_IST)

Thanks for assistance !