6 Replies Latest reply: Mar 11, 2011 8:02 AM by Hilmi Gunhan RSS

    sum with multiple comditions

    Hilmi Gunhan

      Hello everyone,

      I am in a trouble in my Qlikview project. I am desinging a chart that has two comparison columns, sum of minimum date (APKO_RAPOR_TARIHI) and sum of maximum date. Moreover I have one more criteria for these calculation (APKO_MT_TIP =0).

      I wrote down this formula but it did not return anything. Can anyoen help ?

       

      =Sum ( {$< APKO_RAPOR_TARIHI=(=max(APKO_RAPOR_TARIHI),APKO_MT_TIP={APKO_MT_TIP=0}>} total APKO_MT_TL_BAKIYE)