topic Dual Function in QlikView

Dual Function

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Dual Function

Aurelien_Martinez — Thu, 05 Jan 2017 13:43:02 GMT

Hi,

Can you share your script ?

Aurélien

Re: Dual Function

Anonymous — Thu, 05 Jan 2017 13:53:49 GMT

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

Re: Dual Function

sunny_talwar — Thu, 05 Jan 2017 13:59:03 GMT

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

Re: Dual Function

Aurelien_Martinez — Thu, 05 Jan 2017 14:05:51 GMT

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

Re: Dual Function

Anonymous — Thu, 05 Jan 2017 14:07:01 GMT

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

Re: Dual Function

sunny_talwar — Thu, 05 Jan 2017 14:08:05 GMT

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

Re: Dual Function

Anonymous — Thu, 05 Jan 2017 14:12:15 GMT

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

Re: Dual Function

Anonymous — Thu, 05 Jan 2017 14:13:18 GMT

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

Re: Dual Function

Aurelien_Martinez — Thu, 05 Jan 2017 14:19:02 GMT

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

Re: Dual Function

Anonymous — Fri, 06 Jan 2017 05:41:08 GMT

Now I'm getting like this. I don't need like this, I want only the unique values in the list box and also when I write expression in text object, it should be like this....

Plz help me, and you guys getting what I'm trying to say?

Re: Dual Function

vinieme12 — Fri, 06 Jan 2017 05:49:16 GMT

Your script should be

DUAL (If (billablehrs >7,'billable',if (billablehrs <1,'non billable','partially billable')),billablehrs) as projecthrs_status,

Please post script / expression content as text if you want ppl to help you better

Re: Dual Function

Anil_Babu_Samineni — Fri, 06 Jan 2017 06:19:12 GMT

I am not sure, I understand why it is not working. See, In my Application i've done with Duplicate in front end I got only unique names.

Check this and if still getting same issue try to share sample application why it is not working. We may look those same

I used this in List Box. Can you copy your expression on List box and then see whether Duplicate will repeat or not enclosed is attached for ref

=If(Dem='A', 'Anil', If(Dem='B', 'Babu', If(Dem='C', 'Samineni','Samineni')))

Re: Dual Function

sanjay006 — Mon, 15 May 2017 09:56:54 GMT

Short the second dimension alphabetically.

Re: Dual Function

Peter_Cammaert — Mon, 15 May 2017 10:39:34 GMT

For good measure, here are somme points of attention when dealing with the dual() function. You can use them to decide whether dual() is a fit for your situation:

Dual() creates a dual value with both a text and number representation. They become inseparable.
When dual values are stored in a field, they can repeat the text representation for different numeric vlaues, but they cannot repeat the numeric representation with a different text value. Each number can only have one text value. That's the way a field symbol table works.
When using dual values in your document scripts and expressions, the text value will be used for displaying values, and the number value will be used for sorting and calculations. Although this behavior is also context-sensitive in some situations.

The multiple identical strings in your listbox are there because it displays the text values for different numerical values. The listbox in your screenshot contains only three text values tied to 6 different numerical values. The text values are displayed, but the numerical values are used for sorting and filling the listbox. This effect is identical to the one you get when you create date values for all days in a single month, and you then attach date format string 'MM-YYYY' to those individual date values. That results in a listbox with 31 identical 'May-2017' strings for the current month.

Re: Dual Function

sanjay006 — Mon, 15 May 2017 10:49:37 GMT

Sir !

So can we short this expression by string ? instead of numbers. I want this to be shorted in alphabetically order.

Re: Dual Function

Peter_Cammaert — Mon, 15 May 2017 10:57:27 GMT

You mean 'sorted', not blowing fuses? Yes you can. In the sort tab, select Text and a suitable order.

Re: Dual Function

sanjay006 — Mon, 15 May 2017 11:33:54 GMT

But It's not working . I have attached the file i need the second dimension should be shorted alphabetically .

Re: Dual Function

sanjay006 — Mon, 15 May 2017 11:40:46 GMT

Sir !

But It's not working . I have attached the file i need the second dimension

should be shorted alphabetically .

Thanks & Regards,

Sanjay Gupta

BI. Consultant - Business Intelligence

Ph(+91)7042094738 Skype:sanjaymail006

IRT Digital Analytics Solutions

Pvt. Ltd.

On Mon, May 15, 2017 at 4:27 PM, Peter Cammaert <qcwebmaster@qlikview.com>

Re: Dual Function

Peter_Cammaert — Mon, 15 May 2017 11:55:17 GMT

Better create a new discussion for this.