Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
Not applicable

Display 2 charts about same field with different value in one sheet

Hello all,

I'm new to Qlik and i have a problem, maybee very easy to solve for you, but I don't find answers on the Web...

I want to display 2 charts about same field with different value in one sheet. I explain :

I have a datasource which looks like this example :

Indicator           Value                Date

I1                         50               01/01/2014

I2                         60               01/01/2014

I3                         30               01/01/2014

I1                         53               01/02/2014

I2                         52               01/02/2014

I3                         78               01/01/2014

...                         ...                         ...

On a single sheet, i wan't to display :

     - one chart about indicator I1

     - one (other) chart about indicator I2

I know i can display one chart, and change the value of my indicator using a filter, but it's really important for me to view all indicators on the same sheet.

Maybee on way would be to link a filter with a chart, is it possible ?

Maybee there is an other way using expressions...

Thanks for your help,

Baptiste

1 Solution

Accepted Solutions
tap
Contributor

Re: Display 2 charts about same field with different value in one sheet

A couple of ways spring to mind

Limit your dimension by using a simple IF statement. eg

IF(Indicator='l1',Indicator)

This will then only display the graph for l1. You may need to hide the null values.

The second way is set analysis in the measure.

Use an expression like:

SUM({<Indicator={'l1'}>}Value)

This should then only show you values when Indicator is l1.

2 Replies
tap
Contributor

Re: Display 2 charts about same field with different value in one sheet

A couple of ways spring to mind

Limit your dimension by using a simple IF statement. eg

IF(Indicator='l1',Indicator)

This will then only display the graph for l1. You may need to hide the null values.

The second way is set analysis in the measure.

Use an expression like:

SUM({<Indicator={'l1'}>}Value)

This should then only show you values when Indicator is l1.

Not applicable

Re: Display 2 charts about same field with different value in one sheet

Thanks Tim, it is exactly what i want to do !