Discussion Board for collaboration on QlikView Layout & Visualizations.
I'd like to have a workspace with two grapics (pivot tables):
1) Shows all revenue by project
2) Shows revenue by projects, but only those aded in the last month, based on a colum on theoriginal data that informs in the data is "NEW" or "OLD".
I'm trying with a simple "DATA="NEW"" dimension, but it doesn't work.
How can I do that?
try like that
Hun, I was mistaking ' with ".
I might be missing some theory, but tried using a Conditional on Dimensioon and on Expressions, still not worked.
In the end used an "if" in the expressions
Instead of SUM(REVENUE)
If creates the performance issues. So you can use set analysis
Hope this helps you.