1 Reply Latest reply: Apr 6, 2017 2:37 AM by Marcus Sommer RSS

    Sub query in Chart expression

    Chanon Hemtanon

      HI ,

      I try to find sub query in this blog but cannot found related.

       

      Somebody help me think about transforming sql code below to qlikview expression in chart object please.

       

      select store_code,sum(sale) as Total_sale

      from Fact_table

      where ticket_id in (select ticket_id from fact_table where productid = '8853474029876')

      group by store_code

       

      = Sum ({$<ticket_id = {"?????"}>} sale)

       

      this is complex formular please help , thank you so much.