topic Re: Need Help in QlikView

Need Help

paulwalker — Mon, 17 Aug 2015 15:13:14 GMT

Hi Community,

I need one clarification..

LOAD *, Dual(Category, Cost) as Dual;

LOAD * Inline [

Date, Category, SubCAT, Cost

1/1/2012, LapTop, SML, 50

5/5/2012, LapTop, SML, 300

1/1/2012, A/C, SML, 310

3/2/2012, A/C, Big, 240

3/2/2012, Nokia, MDM, 160

7/7/2012, Laptop, MDM, 90

9/18/2012, Samsung, SML, 25

9/30/2012, Samsung, Big, 21

];

If i am using DUAL() function, Dual(Category, Cost) as Dual

what will happen here??

Please can you explain anyone???

Re: Need Help

paulwalker — Mon, 17 Aug 2015 15:14:51 GMT

is this only sorting purpose????

Re: Need Help

Oleg_Troyansky — Mon, 17 Aug 2015 15:21:37 GMT

Paul,

your field Dual will contain both the textual value = Category and the numeric value = Cost. So, when the field is used as a chart dimensions or everywhere else, where the text is expected, the textual value will be displayed, and when the field is used for sorting or math, the numeric part will (or can) be used.

Think of the field Month - it shows you Jan, Feb, Mar, ... yet it's sorted numerically. Your dual field will act similarly.

cheers,

Oleg Troyansky

QlikView Your Business: An expert guide to Business Discovery with QlikView and Qlik Sense

Re: Need Help

sunny_talwar — Mon, 17 Aug 2015 15:22:57 GMT

Not really sure why you are creating Dual field, because I am almost certain that you can use Cost field to sort the same way as it would be sorted by Dual field. So not really sure what benefit it is giving here.

Re: Need Help

ganeshreddy — Mon, 17 Aug 2015 15:23:06 GMT

Hi Paul,

This link may help you, given clear explanation.

QlikView Addict: QlikView Functions: dual()

Best Regards,

Ganesh Reddy

Re: Need Help

jagan — Mon, 17 Aug 2015 15:28:26 GMT

HI,

Dual provides multi datatype feature, generally this is used for Sorting functions. Check this link for detailed explanation

How to use- Dual()

Regards,

Jagan.