Discussion Board for collaboration on QlikView Scripting.
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
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.