1 Reply Latest reply: May 31, 2016 5:05 AM by PAUL YEO RSS

    Diff between Pick(Match and with out Pick(Match ?

    PAUL YEO

      Hi All

       

      I am introduce by some one here using the Pick(Match approach for compute different expression in one table or chart.

       

      Now i try to using another approach with out Pick(Match , i find that it help to speed up a lot , compare to using Pcik(Match does cause out of memory issue.

       

      My question is can some one tell me when i insert a expression below :-

       

      Sum({<$(ColumnDim601)={$(ColumnDim601)}>}Amount/1000)/$(Columndim89)

       

      I notice that QV will take time to compute eXP or rEVENUE. and when i close the QV file and re-open again , QV does not need to take time to compute the result , it immediately display the value.

       

      my i ask it is QV store the compute value in the QVW file ? and it just recall the value when use click on it again ? Does this value keep forever ? what if i do a binary load , why the compute value still keep some where.

       

      Hope some one can share with me.

       

      Paul