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

Show last 3 month's value on table

Dear community!

I'm building a Table and I can't find the straight way to get to this solution.

I attached a JPG of what I have so far: a Table with values for every Automobile Holding and how many mentions it has.

In the right, I built a comparative table that shows me the total of mentions for each month with a variable.

I need to be able to calculate the difference, month on month, for each one of the Auto Holdings (Grupos).

Can anybody help me sort the expression out?? I can't seem to get it to work

Thanks! 😃

1 Reply
marcus_sommer

You could use interrecord-functions like Missing Manual - Above() and Below() to access other rows/columns witin your chart. Another way might be to create for each column an expression and to use set analysis within them: Set Analysis: syntaxes, examples.

- Marcus