Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Insert comparative field

Hello,

I'm having trouble creating the following situation:

In the attached file, if you have a table watching a table A1 and A2, must take the field values ​​"META" for table A2 considering the value of last "MES" ie when I select "AGO" (August), the table A1 should I bring values ​​AGO (August) and the field META (Goal) bring me the value of JUL (July) in order to know if the value I am quoting the current month is less than or greater than the value quoted in the previous month.

Tags (1)
1 Solution

Accepted Solutions

Re: Insert comparative field

See attached qwv


talk is cheap, supply exceeds demand
3 Replies

Re: Insert comparative field

See attached qwv


talk is cheap, supply exceeds demand
Not applicable

Re: Insert comparative field

Thank G Wassenaar!

Not applicable

Re: Insert comparative field

G Wassenaar, is possible in the same situation when the value of the previous month is 0 it will bring the lowest value of the first record to find?

Example: August target value is July, but July is equal to 0, then it bring me the value of June.

Community Browser