Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone,
I need urgent assistance with a problem I'm facing in Qlik. I have a dashboard with a table, as shown in the image below.
I want to modify this table to include a filter with the following requirements:
I’m not sure what the best approach is to achieve this. I would really appreciate it if someone could provide a step-by-step solution.
Thank you so much for your help!
I have created a sample data to generalize a bit your question allowing me to ask questions in order to ensure that we are on the same page regarding the nature of the issue:
NOME, CHAPAL, D1, D2, DN
nome1, 10, d11, d21, dn1
nome1, 100, d12, d22, dn2
nome2, 20, d13, d23, dn3
nome2, 200, d14, d24, dn4
nome3, 300, d15, d25, dn5
My understanding is that you need to show only 3 records from the above table, right:
NOME, CHAPAL, D1, D2, DN
nome1, 100, d12, d22, dn2
nome2, 200, d14, d24, dn4
nome3, 300, d15, d25, dn5
This can be done by creating a calculated dimension that either shows certain NOME value or null (this way you can add the rest of the dimensions freely):
So my solution for this scenario would be this calculated dimension:
=if(aggr(nodistinct Max(CHAPAL), NOME)=CHAPAL,NOME,NULL())
=if(aggr(nodistinct Max(CHAPAL), NOME)=CHAPAL,NOME,NULL())
This will result null for certain records that you can easily hide by ticking off the "include null values" checkbox in the table tools (in edit view).
I have created a sample data to generalize a bit your question allowing me to ask questions in order to ensure that we are on the same page regarding the nature of the issue:
NOME, CHAPAL, D1, D2, DN
nome1, 10, d11, d21, dn1
nome1, 100, d12, d22, dn2
nome2, 20, d13, d23, dn3
nome2, 200, d14, d24, dn4
nome3, 300, d15, d25, dn5
My understanding is that you need to show only 3 records from the above table, right:
NOME, CHAPAL, D1, D2, DN
nome1, 100, d12, d22, dn2
nome2, 200, d14, d24, dn4
nome3, 300, d15, d25, dn5
This can be done by creating a calculated dimension that either shows certain NOME value or null (this way you can add the rest of the dimensions freely):
So my solution for this scenario would be this calculated dimension:
=if(aggr(nodistinct Max(CHAPAL), NOME)=CHAPAL,NOME,NULL())
=if(aggr(nodistinct Max(CHAPAL), NOME)=CHAPAL,NOME,NULL())
This will result null for certain records that you can easily hide by ticking off the "include null values" checkbox in the table tools (in edit view).
It worked perfectly! I really appreciate your help—thank you so much!!