Qlik Community

Qlik Sense Cloud Discussions

Highlighted
xiyuzw1113
New Contributor III

Selection some values from a fields

Hi I currently have problems again at this point.

I have two main tables below, each table has Question no as the option, but for first table, I would limit the Question no= Cus.Q1, Cus Q2, Cus.Q3,Cus.Q4,Cus.Q5, and for second one is Cus.Q6-Cus.Q10.

I tried to use the set expression, but it not works....I need some suggestions. Thanks a lot!

Capture.PNG

2 Replies
Partner
Partner

Re: Selection some values from a fields

What is the expression you have used?

It should be

For 1st Table-

Count({<[Question No.] = {'Cus.Q1', 'Cus Q2','Cus.Q3','Cus.Q4','Cus.Q5'}>}Responses)

For 2nd Table -

Count({<[Question No.] = {'Cus.Q6', 'Cus Q7','Cus.Q8','Cus.Q9','Cus.Q10'}>}Responses)

Partner
Partner

Re: Selection some values from a fields

Change Field name as per your data model.