Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Partner - Specialist III
Partner - Specialist III

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
Partner - Master
Partner - Master

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
Author

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
Author

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
Partner - Specialist III
Partner - Specialist III

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
Author

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

phaneendra_kunc
Partner - Specialist III
Partner - Specialist III

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
Author

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
Partner - Specialist III
Partner - Specialist III

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.