Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Error command which worked with table files

I just put all my test material into a mysql server and trying to fetch the data from there...

But Im trying to use the scripting from the original qlikview file, but I have some problems

When I use "Dual(Month(created) & ' ' & Year(created),year(created) & num(month(created), '00')) as YearMonth,"

I get this error:

Skærmbillede 2012-07-11 kl. 16.06.17.png

Script(until now)

ODBC CONNECT32 TO Spixx.com;
SQL SELECT `order_id`,
     `user_id`,
      Date(created) as created,
      Day(created) as Day,
      Month(created) as Month,
      Year(created) as Year,
      Dual(Month(created) & ' ' & Year(created),year(created) & num(month(created), '00')) as YearMonth,
     `product_id`,
     `currency_id`,
     amount,
     `count`,
     first
FROM bi.`business_intelligence_spigo_order`;

If you remove that line it will load just fine?

1 Solution

Accepted Solutions
MayilVahanan

Hi,

     There is no function like Dual in sql script. So only its show error..

Try like this:

Load

user_id, 

      Date(created) as created,

      Day(created) as Day,

      Month(created) as Month,

      Year(created) as Year,

      Dual(Month(created) & ' ' & Year(created),year(created) & num(month(created), '00')) as YearMonth,

     product_id,

     currency_id,

     amount,

     count,

     first;

SQL SELECT order_id,

     user_id,

      Date(created) as created,   

      product_id,

     currency_id,

     amount,

     count,

     first

FROM bi.`business_intelligence_spigo_order`;

Hope it helps

Thanks & Regards,
Mayil Vahanan R

View solution in original post

3 Replies
MayilVahanan

Hi,

     There is no function like Dual in sql script. So only its show error..

Try like this:

Load

user_id, 

      Date(created) as created,

      Day(created) as Day,

      Month(created) as Month,

      Year(created) as Year,

      Dual(Month(created) & ' ' & Year(created),year(created) & num(month(created), '00')) as YearMonth,

     product_id,

     currency_id,

     amount,

     count,

     first;

SQL SELECT order_id,

     user_id,

      Date(created) as created,   

      product_id,

     currency_id,

     amount,

     count,

     first

FROM bi.`business_intelligence_spigo_order`;

Hope it helps

Thanks & Regards,
Mayil Vahanan R

View solution in original post

Not applicable
Author

what do you mean there are no dual in sql script?

I throught "dual" were a qlikview function - How do I solved this?

Not applicable
Author

aaaah, I understand now

Thank everything works now 🙂