Script Error

[nikhilgarg]

Hey,

I have a dashboard with A , B , C , D as dimension in same order.

My script is:

Load

E,

applymap('table1' , 'E', 'Unknown') as A,

applymap('table2' , 'E', 'Unknown') as B,

applymap('table3' , 'E', 'Unknown') as C ;

Now problem is when i am applying the Sorting as per the expressions then for the known values of A,B,C it is working fine but for value of A,B,C as Unknown sorting is not happening. They are coming in the last.

What to do?

Thanks

[MK_QSL]

Remove 'E' and Use E... not single quotes..

[nikhilgarg]

Hey,

dats a typing error . Plz ignore that quote with E

[vvvvvvizard]

Try

Load

E,

applymap('table1' , 'E', Dual(('Unknown'),1) as A,

applymap('table2' , 'E',Dual(( 'Unknown'),2) as B,

applymap('table3' , 'E', Dual(('Unknown'),3) as C ;

[nikhilgarg]

Hey,

Thanks but how would this help?? ANd what does number indicate here?

Thanks

[MK_QSL]

Dual will sort 'Unknown' as String and Text Both... So for Unknown of A, number value is 1, for B 2 and for C 3...

If this is not working for you, kindly provide some sample data to work..

[nikhilgarg]

Hey,

Thanks but i didn't get you. I also go thru Qlikview content about Dual() but didn't understand much. Can you please explain more.

[MK_QSL]

provide sample data please..