topic Re: Script Error in QlikView

Script Error

nikhilgarg — Fri, 10 Apr 2015 11:34:20 GMT

Hey,

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

My script is:

Load

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

Re: Script Error

MK_QSL — Fri, 10 Apr 2015 11:48:03 GMT

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

Re: Script Error

nikhilgarg — Fri, 10 Apr 2015 11:50:40 GMT

Hey,

dats a typing error . Plz ignore that quote with E

Re: Script Error

vvvvvvizard — Fri, 10 Apr 2015 11:53:16 GMT

Try

Load

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

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

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

Re: Script Error

nikhilgarg — Fri, 10 Apr 2015 11:57:29 GMT

Hey,

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

Thanks

Re: Script Error

MK_QSL — Fri, 10 Apr 2015 12:11:07 GMT

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

Re: Script Error

nikhilgarg — Fri, 10 Apr 2015 12:26:49 GMT

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.

Re: Script Error

MK_QSL — Fri, 10 Apr 2015 12:37:15 GMT

provide sample data please..