topic Re: expression inline in QlikView

expression inline

adiarnon — Thu, 28 Jul 2016 08:51:14 GMT

hi,

im tring to add an expression inline-

DEL_INLINE:
LOAD * INLINE
[_DEL_View,_DEL,_Del_Measure
Quantity,1,num(sum({<SO_DELIVERED_STATUS=,[DELIVERY STATUS]=,SO_TYPE-={'1SLS','SRV'}>}SO_QTY_DEL),'#,##0')
Sale (K$),2,num(sum({<SO_DELIVERED_STATUS=,[DELIVERY STATUS]={'Delivered but Late','Delivered on time'},SO_TYPE-={'1SLS','SRV'}>}SO_LINE_SALES_VALUE_USD)/1000,'#,##0')
STD (K$),3,num(sum({<SO_DELIVERED_STATUS=,[DELIVERY STATUS]={'Delivered but Late','Delivered on time'},SO_TYPE-={'1SLS','SRV'}>}SO_LINE_STD_VALUE_USD)/1000,'#,##0')
];

i have two problem:

1. in my expression i have , so its taking the expression until the ,

2. i have in my set analysis field with space so i added [ ] and its taking the expression until the ]

what can i do?

adi

Re: expression inline

Frank_Hartmann — Thu, 28 Jul 2016 08:55:15 GMT

try to set the expression in between quotation marks.

hope this helps

Re: expression inline

gautik92 — Thu, 28 Jul 2016 08:58:35 GMT

I dont think you can use set analysis in scripting

Re: expression inline

adiarnon — Thu, 28 Jul 2016 08:59:33 GMT

tnx,

its resolve the , problem

but not the []

Re: expression inline

sunny_talwar — Thu, 28 Jul 2016 09:00:45 GMT

Try this may be:

DEL_INLINE:

LOAD * INLINE "

_DEL_View|_DEL|_Del_Measure

Quantity|1|num(sum({<SO_DELIVERED_STATUS=,[DELIVERY STATUS]=,SO_TYPE-={'1SLS','SRV'}>}SO_QTY_DEL),'#,##0')

Sale (K$)|2|num(sum({<SO_DELIVERED_STATUS=,[DELIVERY STATUS]={'Delivered but Late','Delivered on time'},SO_TYPE-={'1SLS','SRV'}>}SO_LINE_SALES_VALUE_USD)/1000,'#,##0')

STD (K$)|3|num(sum({<SO_DELIVERED_STATUS=,[DELIVERY STATUS]={'Delivered but Late','Delivered on time'},SO_TYPE-={'1SLS','SRV'}>}SO_LINE_STD_VALUE_USD)/1000,'#,##0')

" (delimiter is |);