Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More

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)

)

Highlighted
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!

View solution in original post