Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikView forum consolidation is complete. Labels are now required. LEARN ABOUT LABELS
cancel
Showing results for 
Search instead for 
Did you mean: 
abhinavbose
Creator III
Creator III

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
abhinavbose
Creator III
Creator III

Screenshot_3.png

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

View solution in original post

20 Replies
amartinez35
Partner
Partner

Hi,

Can you share your script ?

Aurélien

abhinavbose
Creator III
Creator III

Screenshot_3.png

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

View solution in original post

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 ....

amartinez35
Partner
Partner

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

abhinavbose
Creator III
Creator III

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

abhinavbose
Creator III
Creator III

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

abhinavbose
Creator III
Creator III

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

amartinez35
Partner
Partner

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