topic Re: Filter Data for selected Objects only in QlikView

Filter Data for selected Objects only

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

I have a requirement where I am displaying month over month trend chart.

Here I want to display all the monts available in data sets and even though user selects specific month(Data should not filter on selecting month filter). But all other filters like business line etc should be able to filter the trend chart.

Can any ony one assist me to achive the functionality.

Many thanks in advance!

Re: Filter Data for selected Objects only

sunny_talwar — Tue, 15 Nov 2016 11:57:10 GMT

Add set analysis to ignore selection in month field

{<Month>} or {<Month = >}

Re: Filter Data for selected Objects only

dsharmaqv — Tue, 15 Nov 2016 12:07:22 GMT

Thanks sunny

Can you provide me with sample.

Re: Filter Data for selected Objects only

sunny_talwar — Tue, 15 Nov 2016 12:09:12 GMT

I won't be able to create a sample, but if you share you expression, I might be able to suggest you places where you need to add the above set analysis

Re: Filter Data for selected Objects only

sunny_talwar — Tue, 15 Nov 2016 12:11:33 GMT

Also check here to learn how to use Set Analysis:

http://www.learnqlickview.com/qlikview-set-analysis-basics/

Re: Filter Data for selected Objects only

dsharmaqv — Tue, 15 Nov 2016 12:23:10 GMT

Nothing special in expression tab.

Avg(Fraud score)

Sum(Count)

Re: Filter Data for selected Objects only

sunny_talwar — Tue, 15 Nov 2016 12:32:06 GMT

So try this:

Avg({<Month>}Fraud score)

Sum({<Month>}Count)

Re: Filter Data for selected Objects only

Anonymous — Tue, 15 Nov 2016 12:32:18 GMT

Avg({<Month=>}Fraud score)

Sum({<Month=>}Count)