topic Re: how to filter based on criteria based on the selected field value ? in App Development

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

RaghuRathinam — Fri, 13 Nov 2020 13:33:15 GMT

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.

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

Gabriel — Fri, 13 Nov 2020 16:16:14 GMT

@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.

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

QFabian — Fri, 13 Nov 2020 17:10:18 GMT

Hi @RaghuRathinam

try this please :

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

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

RaghuRathinam — Mon, 16 Nov 2020 07:57:49 GMT

@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.

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

MayilVahanan — Mon, 16 Nov 2020 08:21:49 GMT

Hi @RaghuRathinam

Try like below

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

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

o/p:

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

RaghuRathinam — Mon, 16 Nov 2020 10:14:11 GMT

@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 ?

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

QFabian — Mon, 16 Nov 2020 13:35:50 GMT

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

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

RaghuRathinam — Mon, 16 Nov 2020 16:08:23 GMT

@QFabian

Can you please provide the QVF file ?

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

QFabian — Mon, 16 Nov 2020 17:44:08 GMT

Sure!, here it is