Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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?
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.
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
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
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.
What would the syntax of the script be? Can you please help
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
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
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.