3 Replies Latest reply: Nov 27, 2012 1:27 AM by Rohit Narvekar RSS

    How to write following SQL query in Qlikview

      Hello All,

       

      I am trying to write SQL query with following format in Qlikview

       

      SQL SELECT columname as CL1,

                           columname as CL2,

                           (Select Case when condition then action

                                       Case when condition then action

                                      end

                             from table1,table2 where table1.col=table2.col and table1.col2='xyz' )    as CL3,

                           (Select Case when condition then action

                                       Case when condition then action

                                         end

                            from table1,table2 where table1.col=table2.col and table1.col2='xyz' )    as CL4,

                             colomnname as CL5

            FROM table

          where condition;

       

      Query working in SQL but it is not working in Qlikvew.

      It is giving me following error

       

      ORA-01427: single-row subquery returns more than one row"

       

      I googled this error but still couldnt figure out how to write above query in Qlikview.

       

      Thank you,

      Regards,

      Rohit.