Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
NEW webinar Dec. 7th: 2023 Outlook, A Pivotal Year for Data Integration SIGN ME UP!
cancel
Showing results for 
Search instead for 
Did you mean: 
shtewari
Contributor
Contributor

Create field that contains all combinations of two fields

Hi all, 

I am trying to build a visualization which requires a combination of few fields. The detailed information is provided below.

User Dissatisfied (if any combination from below TRUE):-

-Average to low Classification  (Field 1)

-Falls in Class A and Class B (Field 2)

-Salary in average to low category (Field 3)

-Read Count less than 15000 (Field 4)

I am having all the above field values but am not able to get the combination of them. Like any two or more conditions are true then the used is dissatisfied.

Similarly I'm having few conditions for user satisfaction and for them also if any two or more conditions are true then the user is satisfied.

I cannot provide any qvf or dataset because it is confidential

 

Thank you for any help!

Labels (2)
3 Replies
Zhandos_Shotan
Partner - Creator II
Partner - Creator II

Hi

 

Use 1 and 0 value for fields that indicate (1) dissatisfied conditions

Then check (Field 1 + Field 2 + Field 3 + Field 4)  > = 1

 

Regards

Pawlak3B
Contributor
Contributor

A data frame containing one row for each combination of the supplied factors. The first factors vary fastest TellPopeyes.

ChiragPradhan
Creator II
Creator II

Hi

See attached app. 

If it is what you are looking for, consider marking it as resolved.