Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Creating Filter in UI using 3 field list items

Hi All,

I have a script in data load editor of Qlik sense that has 3 fields and I need to create a filter at UI called the category (column 1 in the attached image).  Each of the 3 fields has it's own list as shown below in image (ex List Item 1,2 etc).  Each field list item is independent of other list items.  Can anyone help me with what should be the syntax of creating category Filter for UI?

Thanks!
Monica


9 Replies
phaneendra_kunc
Valued Contributor III

Re: Creating Filter in UI using 3 field list items

This new Category filter needs to target all those 3 fields? Or do you have a field called Category in the script? if not can you derive?

Also lets say if i pick "Item2" from category filter what is your expected behavior on those 3 fields?

fkeuroglian
Honored Contributor

Re: Creating Filter in UI using 3 field list items

Hi Monica,

can you explain better what is the final result

Monica podrias explicar mejor o poner un ejemplo claro de que es lo que queres, no quedo muy clara tu explicacion, grs!

Fernando K.

Not applicable

Re: Creating Filter in UI using 3 field list items

The Category filter needs to be created in UI (there is no field currently present in the script).  If user picks Item 1 then records from list item1 (Field 1), list item2 (Field 2) and list item3 (Field 3) are displayed. 

Let me know if this clarifies your doubt

Thanks,

Monica

Not applicable

Re: Creating Filter in UI using 3 field list items

The Category filter needs to be created in UI.  The category filter is based on user selection i.e. if user picks Item 1 in category filter (then records from list item1 (Field 1), list item2 (Field 2) and list item3 (Field 3) are displayed. 

Let me know if this makes sense

Thanks,

Monica

phaneendra_kunc
Valued Contributor III

Re: Creating Filter in UI using 3 field list items

So how is this category filter relates to rest of the 3 fields?

I think best bet would be to create a new field "Category" in the script to get to what you want. I Dont think there is way in Sense where you can create a single field in UI and filter in 3 other fields with out any relation.

Not applicable

Re: Creating Filter in UI using 3 field list items

What would the syntax of the script be?  Can you please help

phaneendra_kunc
Valued Contributor III

Re: Creating Filter in UI using 3 field list items

I can help you with the syntax, but I need to know the relation between this new category field and those 3 fields. Meaning item1 from category is related to list item1 (Field 1), list item2 (Field 2) and list item3 (Field 3)?

Phani

Not applicable

Re: Creating Filter in UI using 3 field list items

There is no relationship between the List Item 1 (Field 1) and List Item 1 (Field 2) and List Item 1 (Field 3).  The values are also completely different between the List Items on the three fields.  Does the question make sense

Monica

phaneendra_kunc
Valued Contributor III

Re: Creating Filter in UI using 3 field list items

So if i understand correctly when you pick "Apple" from Category filter (Island) then you are trying to pick "Apple" in Field1, Field2 & Field3. If that is the case it is hard to achieve in Sense.

This could have been easier in Qlikview as you can use Triggers.

1. I would suggest to use the set analysis to accomplish this.

Create a variable called "vCategory" and expression for this variable as =chr(39)&Concat(Category,chr(39)&',')&chr(39)

And your chart expressions like like

sum({<Field1={$(vCategory)},Field1={$(vCategory)},Field1={$(vCategory)}>}sales)

2.There are some triggers using Qlik Sense "GitHub - stefanwalther/sense-navigation: Sheet Navigation + Actions for Qlik Sense." but this doesn't have option to pick (Select multiple values in a field) 3 fields at a time. U can take this extension and modify to allow 3 fields.

Hope this helps.

Community Browser