Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

reinholdgraf
Contributor

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

Tags (1)
1 Solution

Accepted Solutions
bwisenosimenkg
Valued Contributor

Re: Set-Analysis,

How about:

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

6 Replies
darkhorse
Valued Contributor

Re: Set-Analysis,

Hello,

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

BR

Serhan

reinholdgraf
Contributor

Re: Set-Analysis,

yes (attachement in the original post)

bar chart - ok

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

bwisenosimenkg
Valued Contributor

Re: Set-Analysis,

How about:

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

reinholdgraf
Contributor

Re: Set-Analysis,

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.

darkhorse
Valued Contributor

Re: Set-Analysis,

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
Contributor

Re: Set-Analysis,

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 !