Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
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
MVP & Luminary
MVP & Luminary

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