New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Ignore specific selections in Line chart

Hi Guys,

I am really struggeling with something in Qlik Sense. (I am kind of new)

In my app I have 3 filters (Accounting, Year, Banks).

In one of my visualisations (Line Chart) I want to show the development of the Tier 1 Ratio from 2010 to 2016 for just one bank.

In the same graph the maxium as well as the Minimum of the Tier 1 Ratio for all Banks should be displayed. And there is my Problem

I have tried the following:

Min( aggr(  (sum({\$<Finanzdaten={'Kernkapital'}> * 1<[Bank]=> }  Wert) /

sum({\$<Finanzdaten={'RWA Gesamt'}> * 1<[Bank]=>} Wert)),

Jahr, [Bank]  ))

Kernkapital = Tier 1 Capital would be the translation.

I am trying to calculate for each year and each bank the Tier 1 Ratio and then the minimum of all these Tier 1 ratios should be plotted.

If all of the banks are selected in the filter,this works pretty good. But since I want the formula to work independent of any selection of the bank it does not work as soon as my selection of the Banks changes.

Is it somehow possible to ignore specific selections in a visualization while not ignoring some other selections?

I really hope that you can help me with this issue :-)

Regards

Benjamin

1 Solution

Accepted Solutions
Esteemed Contributor

Re: Ignore specific selections in Line chart

maybe:

Min({<Bank>} Aggr( min({\$<Finanzdaten={'Kernkapital'},Bank=>}Wert) / min({\$<Finanzdaten={'RWA Gesamt'},Bank=>}Wert), Bank, Jahr)  )

8 Replies
Valued Contributor III

Re: Ignore specific selections in Line chart

Yes its possible to ignore selections ,the expression above Bank= which you used does that.

Could you create a sample data so that it can be understood better

Valued Contributor III

Re: Ignore specific selections in Line chart

Not sure but try this

Min( aggr(  (sum({\$<Finanzdaten={'Kernkapital'}, Bank=> * 1<[Bank]=> }  Wert) /

sum({\$<Finanzdaten={'RWA Gesamt'}, Bank=> * 1<[Bank]=>} Wert)),

Jahr, [Bank]  ))

Not applicable

Re: Ignore specific selections in Line chart

Great :-)

Not quite sure how to do this, but I'll just try to explain it:

As I said, I have 3 filter panes:

Accounting: IFRS, HGB

Year: 2010, 2011, 2012, 2013, 2014, 2015, 2016

Banks: Commerzbank, Deutsche Bank, .... and some more

In my data there are the fields: "Finanzdaten" and "Wert". In "Finanzdaten" you can find "Kernkapital" and "RWA Gesamt" while the corresponding value is in the filed "Wert".

Hope this helps you.

Thank you

Not applicable

Re: Ignore specific selections in Line chart

Not working unfortunately.

Not applicable

Re: Ignore specific selections in Line chart

Ok, I think I know now where the problem lies:

That's my formula now:

Min( Aggr( min({\$<Finanzdaten={'Kernkapital'},Bank=>}Wert) / min({\$<Finanzdaten={'RWA Gesamt'},Bank=>}Wert), Bank, Jahr)  )

The Problem is my structured Parameter "Bank" in the aggr-function.

Can I somehow tell the aggr function that it should not regard any selections of the field bank?

Esteemed Contributor

Re: Ignore specific selections in Line chart

maybe:

Min({<Bank>} Aggr( min({\$<Finanzdaten={'Kernkapital'},Bank=>}Wert) / min({\$<Finanzdaten={'RWA Gesamt'},Bank=>}Wert), Bank, Jahr)  )

Not applicable

Re: Ignore specific selections in Line chart

Wow It does work! Thank you so much :-)

So with this Expression {<Bank>} I am able to ignore the selection for Bank?

Esteemed Contributor

Yes.