Show only 2 specific values within a table without using filters

[YannikPrill]

Hey everyone,

sooo first post... here we go 🙂 

I need some help with tables in QlikSense. I need to create a table that shows specific values only without using filters. I do not want it to filter all the charts on the sheet. I just need one specific table to not show all the values in it's database. 

To clearify here's a little exemple: I use a column that includes 100 values. These 100 values are now listed in the table. Without using a filter I want this column to now only show 2 values. Is there a formula or some other way to make that possible? 

I would really appreciate some help 🙂 

Thanks in advance,

Yannik

[vikasmahajan]

try this 

Sum (  {< Filter= {'Text1','Text2'} >}   Value)

[Mauritz_SA · Accepted solution]

Hi Yannik

You have three options:

1. If you always want to show the top 2 (or any n number) then you can use the Limitation option:

Click on Table, Data, Columns, Fehlerbild, Limitation, Fixed number (or any other option) eg. 2.

2. You can "filter" the dimensions using a formula and then return all of the results for the filtered dimension:

=Aggr(ONLY({<Fehlerbild={"Avisierung-nicht-erfolgt","Mengenabweichung-Transportavis-ASN"}>} Fehlerbild),Fehlerbild)

3. You can use something like

Sum({<Fehlerbild={"Avisierung-nicht-erfolgt","Mengenabweichung-Transportavis-ASN"}>} Fehlerbilder) in the Anzahl Fehlerbilder measure. Obviously just change it to be what you need (Sum/Count etc.). You basically just need to add {<Fehlerbild={"Avisierung-nicht-erfolgt","Mengenabweichung-Transportavis-ASN"}>} to your current expression after the first bracket.

Regards,

Mauritz

[YannikPrill]

Hey everyone 🙂 

Thanks for the quick help 🙂 The second option provided a proper solution for my problem 🙂 

(Y) 

[Mauritz_SA]

Great, glad it helped. Please mark it as a solution so that others in the community can also find it 

[YannikPrill]

Marked it 🙂 

How would be the code for not only showing specific values but for excluding specific values? 

I hope you don't mind to help again 🙂 

Greetings from Germany,

Yannik 

[Mauritz_SA · Accepted solution]

Hi Yannik

No problem. Simply put a minus (-) after the equals sign. For example:

=Aggr(ONLY({<Fehlerbild=-{"Avisierung-nicht-erfolgt","Mengenabweichung-Transportavis-ASN"}>} Fehlerbild),Fehlerbild)

Also just make sure that Include null values is not ticked for the dimension under the Columns section of the table.

Hope it helps.

Regards,

Mauritz

[YannikPrill]

Great 🙂 Thanks alot Mauritz!