Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Re: Set analysis to filter fields in chart

So, when you select Data 1 it should filter down to only those rows where the Type is Data 1 (unless you have set analysis to over ride selections), right?

arwinpabz
New Contributor III

Re: Set analysis to filter fields in chart

Exactly! I'm just new to Qlik and I would love to learn more..

sasiparupudi1
Honored Contributor III

Re: Set analysis to filter fields in chart

May be try

If(vSourceType = 'Data 1',

Aggr(Max({$<SourceType = {"Data 1"}>}SourceType),Year,Month),

Aggr(Max({$<SourceType = {"Data 2"}>}SourceType),Year,Month)

)

arwinpabz
New Contributor III

Re: Set analysis to filter fields in chart

I found the right answer somewhere in other post here in community.

I really appreciate your effort by replying  to this post and looking forward to learn more in Qlik!