2 Replies Latest reply: Oct 4, 2017 4:39 AM by Varun Prakash Paulraj RSS

    Multiple Expression vs Multiple Dimension

    Deepak Shrivastava

      Hi,

       

      What would yield a better performance in charts in Qlik - Multiple Expression with 1 dimension? or One expression with multiple dimension

       

      For instance, if I have 2 dimension Time, and Product. And Expression Sum(Units).

       

      Which would be faster?

      a) 2 dimension - Time and Product

           Expression - SUm(Units)

       

      b) Dimension - Time

            Expressions - Sum({<Product={'A'}>}Units),

                                    Sum({<Product={'B'}>}Units)


      considering this being a huge amount of data and having 7-8 products.