This is the error I am getting
Unable to parse query string for Function QUERY parameter 2: PARSE_ERROR:
Encountered "(" at line 1, column 32. Was expecting one of: <EOF> "where"
... "group" ... "pivot" ... "order" ... "skipping" ... "limit" ... "offset"
... "label" ... "format" ... "options" ... "," ... "*" ... "+" ... "-" ...
"/" ... "%" ...
On Friday, October 27, 2017 at 12:28:23 PM UTC+5:30, prashanti wrote:
>
> The query is being used in a third sheet
>
> On Friday, October 27, 2017 at 12:25:43 PM UTC+5:30, prashanti wrote:
>>
>> Can someone please hint me what is the problem with this query?
>>
>> = Query({Query({Sheet1!$A2:$G,Sheet2!$A2:$H},
>> "select Col1,Col2,Col3, MULTIPLY(Col7, Col15) where Col1=Col8 and
>> Col3=Col9 group by Col1, Col2, Col3 label MULTIPLY(Col7, Col15) ''")},
>> "select SUM(Col4) where Col1=" &A2& " and toDate(Col2)= date '"&text(B2,
>> "yyyy-MM-dd")&"' label SUM(Col4) ''")
>>
>
--
You received this message because you are subscribed to the Google Groups
"Google Visualization API" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to google-visualization-api+unsubscr...@googlegroups.com.
To post to this group, send email to google-visualization-api@googlegroups.com.
Visit this group at https://groups.google.com/group/google-visualization-api.
To view this discussion on the web visit
https://groups.google.com/d/msgid/google-visualization-api/b39bfce3-2e5f-4beb-a36a-63723c28a68a%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
