Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikView forum consolidation is complete. Labels are now required. LEARN ABOUT LABELS
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

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

aaaah, I understand now

Thank everything works now 🙂