how to filter based on criteria based on the selected field value ?

[RaghuRathinam]

As I am a beginner to Qliksense, Your support on this will be great appreciated.

I am interested to find the similar entity based on a condition that is selected in QlikSense Application.

I illustrated the same with an easy example :

My DB table looks similar to attached image.

My target is,

When someone selects the Person Name "Pieter" in a filter pane, the another listbox/filterpane should display me the list of Same AGED person names.

In this case, criteria to match is AGE, I would make it multiple criteria as well like Sex, city etc.

How do I accomplish this ? I tried to use IF statements, set expressions and things like that...

But still stuck.

Kindly help me here.

[Gabriel]

@RaghuRathinam 

Step 1: Create a variable i.e called vNameSelected = '=ONLY({<Name={$(=GETFIELDSELECTIONS(Name))}>}Age)'

Step 2: Either listbox or filter use this expression 

=CONCAT({1<Age ={$(vNameSelected)}>} Name,'|',Name)

When you make selection in Name field then you should Names that matches the age of name selected.

That should sort it our for you.

[QFabian]

Hi @RaghuRathinam 

try this please :

=concat({< Name = e({<Name = Name>}), Age = {"=Age"} >} Name, ', ')

[RaghuRathinam]

@Gabriel 

Thanks for your response.  I tried to do, what you said.  It is not working.

Please see the attached test application for your reference.

@QFabian 

In the attached application, in the list box dimensions, i tried your suggestion 

=concat({< Name = e({<Name = Name>}), Age = {"=Age"} >} Name, ', ') as well.

It did not work.

[MayilVahanan]

Hi @RaghuRathinam 

Try like below

=Aggr(concat({<Age = {"=Age"}, Name= >} Name, ', '), Name) <-- it includes the name which u selected

or

=Aggr(concat({< Name = e({<Name = Name>}), Age = {"=Age"} >} Name, ', '), Name) <-- it display the remaining names with same age criteria

o/p:

[RaghuRathinam]

@MayilVahanan 

Thanks for your response.

This way, it works in this test case app which i share.

But in my real case, the number of data is huge.  around 15000 records.

Hence i get a error message like "The hypercube results are too  large" .  Any new ideas ?

[QFabian]

Hi @RaghuRathinam , y just tested and works fine, i just selected 'suresh' and return 'Joseph':

[RaghuRathinam]

@QFabian 

Can you please provide the QVF file ? 

[QFabian]

Sure!, here it is