topic Re: Set analysis to filter fields in chart in QlikView

Set analysis to filter fields in chart

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

Would like to know on how can I filter the fields in Qliksense chart using set analysis.

Currently I am trying this code:

=If(vSourceType = 'Data 1', Only({$<SourceType = {"Data 1"}>}SourceType), Only({$<SourceType = {"Data 2"}>}SourceType))

What I want to return is when user select the Data 1 in selection, then Data 1 will only appear in SourceType field. Else, Data 2 in SourceType.

Thanks in advance!

Re: Set analysis to filter fields in chart

sunny_talwar — Tue, 10 Apr 2018 15:13:47 GMT

Where is the above expression used? What exactly are you trying to display?

Re: Set analysis to filter fields in chart

jmvilaplanap — Tue, 10 Apr 2018 15:17:26 GMT

Hi,

I think is not necessary use "Set Analysis" if you put a list with values "Data 1", "Data 2" etc... and you force it to have one selected value... is enought, isn´t it?

Regards.

Re: Set analysis to filter fields in chart

Anonymous — Wed, 11 Apr 2018 04:12:10 GMT

It's Qliksense dashboard, when dashboard user select these selection, the export button would export the data which exclusively selected.

Don't know what is wrong in my expression in export button.

Re: Set analysis to filter fields in chart

sunny_talwar — Wed, 11 Apr 2018 11:20:53 GMT

Can you try this

=If(vSourceType = 'Data 1', 'Data 1', 'Data 2')

Re: Set analysis to filter fields in chart

Anonymous — Wed, 11 Apr 2018 11:39:53 GMT

Thanks for being patient, Sunny. When I use that expression and hit the download button, it return this data.

No more Data 2 in the field but the count is just the same. I guess it just replace the Data 2, not to export only the Data 1 exclusively.

Is there a set analysis that I can filter the field in Qliksense? Below expression is not working.

=Only({$<SourceType = 'Data 1'>-1<SourceType='Data 2'>}SourceType)

Re: Set analysis to filter fields in chart

sunny_talwar — Wed, 11 Apr 2018 11:47:13 GMT

But isn't vSourceType a variable? I am not sure I am able to follow what you are looking to do...

Re: Set analysis to filter fields in chart

Anonymous — Wed, 11 Apr 2018 11:59:13 GMT

Yes, vSourceType is a variable. This variable toggles if user select Data 1 or Data 2.

Then, expression you provided is what I used here.

But when I download the file, it shows me the whole data. Not filtered by Source Type which user selected.

Apologies if I made you confused.

Re: Set analysis to filter fields in chart

sunny_talwar — Wed, 11 Apr 2018 12:06:08 GMT

Source Type is an Island table? Is it not linked to your data model?

Re: Set analysis to filter fields in chart

Anonymous — Wed, 11 Apr 2018 12:10:17 GMT

It is linked in data model. It's actually part of link table.

Re: Set analysis to filter fields in chart

sunny_talwar — Wed, 11 Apr 2018 12:13:23 GMT

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?

Re: Set analysis to filter fields in chart

Anonymous — Wed, 11 Apr 2018 12:16:17 GMT

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

Re: Set analysis to filter fields in chart

sasiparupudi1 — Wed, 11 Apr 2018 14:10:12 GMT

May be try

If(vSourceType = 'Data 1',

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

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

)

Re: Set analysis to filter fields in chart

Anonymous — Fri, 13 Apr 2018 03:21:11 GMT

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!