topic Re: Dual Function in expression in QlikView

Dual Function in expression

Tue, 03 Mar 2015 08:37:00 GMT

Hi All,

I have used the dual() function in chart's expression, however, the chart show all the original value in data point not what I want by using dual. Could any one please help to tell why the dual function could not work?

Thanks.

Jelly

Re: Dual Function in expression

kiranmanoharrode — Tue, 03 Mar 2015 08:51:08 GMT

Dear Jelly,

Use sorting under sort tab,

Regards,

Kiran

Re: Dual Function in expression

anbu1984 — Tue, 03 Mar 2015 08:53:55 GMT

Can you post sample app

Re: Dual Function in expression

Peter_Cammaert — Tue, 03 Mar 2015 08:55:12 GMT

Can you please explain how you are using the dual() function, what the data is you are trying to combine and what output you are expecting? Thank you.

Re: Dual Function in expression

Colin-Albert — Tue, 03 Mar 2015 09:05:54 GMT

Dual combines a text and numeric value in a single field.

The data is returned as the text value but is sorted using the number by default.

A simple example are month names.

The text data is January, February... December but the data is sorted by month number 1.2... 12

dual(text_value, numeric_value) as filed_name

How are you using Dual and what result do you expect?

Re: Dual Function in expression

Wed, 04 Mar 2015 01:35:07 GMT

Hi all,

Sorry for the sample delay. The following is the chart that I have. But I do not want to have the chart like this.

First I load the data:

LOAD * INLINE [

CustomerOrig, Customer,CustomerOrder,LabelOff

A.cus, A,1, A

B.cus, B,2, B

C.cus, C,3, C

D.cus, D,4, D

E.cus, E,5, E

F.cus, F,6, F

G.cus, G,7, G

H.cus, H,8, H

I.cus, I,9, I

J.cus, J,10, J

K.cus, K,11, K

L.cus, L,12, L

M.cus, M,13,M

];

I use dual() in expression.

Dual(If(year =2009,LabelOff,''), count(customer)*100/count(total <year> customer))

And my dimention is : 1.year 2. CustomerOrder.

Then I click the 'show value on data point' and the dual function could not work......

Jelly

Re: Dual Function in expression

Anonymous — Wed, 04 Mar 2015 03:00:01 GMT

I hope to be proven wrong but I don't think this method works if the bars are created by the dimension..in this case customer order.

Re: Dual Function in expression

Wed, 04 Mar 2015 03:13:15 GMT

Sorry for missing some information. In the load data table, variable 'customer' is the key variable which linked to the main table. So I think the customer dimension is still ok....

Re: Dual Function in expression

jonathandienst — Wed, 04 Mar 2015 05:43:20 GMT

A dual is actually a number with a custom text representation. The option is show the value on the data points, so it is displaying the numeric value, not your text representation. I am not sure what output you are trying to get, but I am not sure if its possible with an area chart.

Jonathan

Re: Dual Function in expression

Wed, 04 Mar 2015 05:49:37 GMT

Hi,

Can dual() be used to show the text?

Re: Dual Function in expression

jonathandienst — Wed, 04 Mar 2015 06:09:43 GMT

With a combo chart, it is possible to make a text-only expression (not a dual) and show this on the data points. Create an expression that returns the text and turn off line, symbol and bar for the expression, then turn on show on data points. I don't think this works for an area chart - but I have never tried.

Re: Dual Function in expression

timanshu — Wed, 04 Mar 2015 06:37:20 GMT

Hi Jelly,

Write your expression inside Num().

like..

Num (Dual(If(year =2009,LabelOff,''), count(customer)*100/count(total <year> customer))).

Re: Dual Function in expression

Wed, 04 Mar 2015 06:49:42 GMT

Thanks... I have tired and it could not work..I would like to show text in the chart.