Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Dimension as Filter in only one graphic

Hello,

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?

Thanks!

4 Replies
Not applicable

Re: Dimension as Filter in only one graphic

try like that

DATA='NEW'

Not applicable

Re: Dimension as Filter in only one graphic

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)

used IF(DATA='NEW',SUM(REVENUE))

Not applicable

Re: Dimension as Filter in only one graphic

Try this

Sum({$<DATA={NEW}>} REVENUE)

MVP
MVP

Re: Dimension as Filter in only one graphic

Hi,

If creates the performance issues.  So you can use set analysis

=SUM(<DATA={'NEW'}>}REVENUE)

Hope this helps you.

Regards,

Jagan.

Community Browser