Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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.

1 Solution

Accepted Solutions
Gysbert_Wassenaar

See attached qwv


talk is cheap, supply exceeds demand

View solution in original post

3 Replies
Gysbert_Wassenaar

See attached qwv


talk is cheap, supply exceeds demand
Not applicable
Author

Thank G Wassenaar!

Not applicable
Author

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.