Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

paulyeo11
Valued Contributor II

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

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

1 Reply
paulyeo11
Valued Contributor II

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

enclosed my QV Doc table 1 with Pick(Match and Table 2 with out.

Community Browser