Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Using set-analysis to filter dimension in line chart

Hi,

I'm trying to filter the dimension of a line chart in such a way that only specific values are shown:

if([Date] < Max({$<[F_FCI_Flag]={1}>}[Date]), MonthName([Date]))


If I put only the set-analysis statement in e.g. a KPI, it yields a value.

However, for the line chart I receive an "invalid dimension" error.

Date is a shared dimension among different fact tables which is why I introduced the "Flag" in order to identify a given facts table.

Can anyone help?

Thanks!

David

1 Solution

Accepted Solutions

Re: Using set-analysis to filter dimension in line chart

or may be

If([Date] < Max({$<[F_FCI_Flag]={1}>}Total [Date]), MonthName([Date]))

3 Replies
antoniotiman
Honored Contributor III

Re: Using set-analysis to filter dimension in line chart

In Calculated Dimension You need to aggregate data.

Try

Aggr(if([Date] < Max({$<[F_FCI_Flag]={1}>}[Date]), MonthName([Date])),Date)

Re: Using set-analysis to filter dimension in line chart

or may be

If([Date] < Max({$<[F_FCI_Flag]={1}>}Total [Date]), MonthName([Date]))

Not applicable

Re: Using set-analysis to filter dimension in line chart

works! Thanks a lot!