Ignore specific selections in Line chart

[#1]

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 🙂

Thank you in advance.

Regards

Benjamin

[kkkumar82]

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

[kkkumar82]

Not sure but try this

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

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

    Jahr, [Bank]  ))

[#4]

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:) 

[#5]

Not working unfortunately.

[#6]

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?

[OmarBenSalem · Accepted solution]

maybe:

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

[#8]

Wow It does work! Thank you so much 🙂

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

[OmarBenSalem]

Yes.
If your question has been answered, don't forget to close the thread by marking correct the correct answer and helpful the answers that helped you.

Thanks,