Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Dual Function in expression

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

12 Replies
kiranmanoharrode
Contributor III

Re: Dual Function in expression

Dear Jelly,

Use sorting under sort tab,

Regards,

Kiran

anbu1984
Honored Contributor III

Re: Dual Function in expression

Can you post sample app

Re: Dual Function in expression

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

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?

Not applicable

Re: Dual Function in expression

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

michael_gardner
Contributor III

Re: Dual Function in expression

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.

Not applicable

Re: Dual Function in expression

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

MVP
MVP

Re: Dual Function in expression

Hi

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

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Not applicable

Re: Dual Function in expression

Hi,

Can dual() be used to show the text?

Community Browser