Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Suggestion required

Please suggest, I have a requirement in my attached sample file:

REQUIREMENT

-------------------------------------------------------------------------------------------

Question [Q1,Q2,Q3,Q4] must be answered as  1 to 10 rating.

Question [Q5] must be answered as 20,25,30,35

Customer is considered as SATISFIED only if he has rated

9,10 (more than 9) as answer for Q1,Q2,Q3,Q4

AND

30,35 (more than 30) as answer for Q5

Customer is considered as DISSATISFIED only if he has rated

1--8 (less than 9) as answer for Q1,Q2,Q3,Q4

AND

20,25 (less than 30) as answer for Q5

Pls suggest in the attached file.

Thanks,

Raja

1 Solution

Accepted Solutions
Gysbert_Wassenaar

See attached qvw.


talk is cheap, supply exceeds demand

View solution in original post

4 Replies
Gysbert_Wassenaar

See attached qvw


talk is cheap, supply exceeds demand
Not applicable
Author

Thanks Gysbert, I appreciate your quick response.

Please see the attached file & Please check the below

Slight extension in requirement:

Question [Q1,Q2,Q3,Q4,Q5,Q6,Q7,Q8] must be answered as  1 to 10 rating.

Question [Q9] must be answered as 1,2,3,4,5

Cust. Satisfied if

----------------------------

Q1,Q2,Q3,Q4,Q5,Q6,Q7,Q8  --> Answered as '>=9' i.e. more than 9

AND

Q9 --> Answered as '>=3' i.e. more than 3

Cust. Dissatisfied if

---------------------------------

Q1,Q2,Q3,Q4,Q5,Q6,Q7,Q8  --> Answered as '<9' i.e. less than 9

AND

Q9 --> Answered as '<3' i.e. less than 3

Thanks,

Raja

Gysbert_Wassenaar

See attached qvw.


talk is cheap, supply exceeds demand

View solution in original post

Not applicable
Author

Perfect Gysbert!!! This is what required.Appreciate your valuable input.

Thanks!!!