This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
I am trying to load script, but it's saying blank field name not allowed. Same script running fine in SQL.
This is the error message.
Here is my script.
sum(il.[Gross Weight]) as ShipWeight,
cn.[Actual Packaging], itm.[Description],
FROM [TBW_BI].[dbo].[dreams$Sales Invoice Line] as il
inner join [TBW_BI].[dbo].[dreams$Sales Invoice Header] as ih
on il.[Document No_]=ih.No_
inner join [TBW_BI].[dbo].[dreams$Consignment] as cn
on ih.[Consignment ID]=cn.[id]
left join [TBW_BI].[dbo].[dreams$Item] as itm
on cn.[Actual Packaging]=itm.[No_]
where ih.[Ship-to Country_Region Code]='HK'
and ih.[Shipment Date]>='2016-10-01' and ih.[Shipment Date]<'2017-03-31'
group by ih.[Order GuID],itm.Description, cn.[Actual Packaging]
Can you try giving the alias for count()?? and others too.
I am agree with Shiva, you should give alias to you calculate field but also to others.
And it will help you for you data model (to avoid sync table for example)
just try by placing the field name in between `` and see, pls note those are not single codes.
sum(il.[Gross Weight]) as `ShipWeight`,
count(il.No_) as 'cntno'
Alias worked Shiva.
Now I have the table , I have to classify them and how many orders under each category ?
Could you attach your application in order to propose you a solution?
Giridhar, To classify your data you can defiine the intervls and use an intervalmatch() function to categorize your data.
Look at this topic about IntervalMatch(). it may be will help you.
You need count(il.No_) change:
count(il.No_) as No