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: 
Anonymous
Not applicable

Dual Function

Guys,

Whenever I use dual function in script, I get duplicate values in the list box after loading the data as shown in the below image. Please help me guys....

Screenshot_2.png

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

Screenshot_3.png

This is the script I'm using....

View solution in original post

20 Replies
Aurelien_Martinez
Partner - Specialist II
Partner - Specialist II

Hi,

Can you share your script ?

Aurélien

Help users find answers! Don't forget to mark a solution that worked for you!
Anonymous
Not applicable
Author

Screenshot_3.png

This is the script I'm using....

sunny_talwar

If you don't want multiple values just assign the flags and don't use dual here

If(Condition1, 'Billable',

     If(Condition2, 'Partially Billable', 'Non Billable')) as ....

Aurelien_Martinez
Partner - Specialist II
Partner - Specialist II

It's because you have multiple value for one label.

For example :

LOAD Dual('toto', id) INLINE [
id
1
2
]
;

This script give duplicate value "toto" because I have two number (1 and 2).

To slove this problem you can remove the dual:

Load

  If(Numbre>7, 'Value',

   If([...]

) as myField

Help users find answers! Don't forget to mark a solution that worked for you!
Anonymous
Not applicable
Author

No, I need multiple values here. So that I have used Dual function here... Is there any alternate solution for this?

sunny_talwar

You need multiple values, but you don't need them? I am confused

Anonymous
Not applicable
Author

Thank you for the reply.... But I didn't get what I expected. It has both text value and numeric value.

Anonymous
Not applicable
Author

I need both text and numeric values here..Plz help

Aurelien_Martinez
Partner - Specialist II
Partner - Specialist II

You need both in the same field or you can have 2 fields ?

Like one with the number and the other with the label ?

Or you can add the number to the label like

Load

  If(Number>7, 'Value ' & Number,

    If([...]

  ) as myField

Help users find answers! Don't forget to mark a solution that worked for you!