Filter Data for selected Objects only

[dsharmaqv]

Hi

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!

[sunny_talwar]

Add set analysis to ignore selection in month field

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

[dsharmaqv]

Thanks sunny

Can you provide me with sample.

[sunny_talwar]

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

[sunny_talwar]

Also check here to learn how to use Set Analysis:

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

[dsharmaqv]

Nothing special in expression tab.

Avg(Fraud score)

Sum(Count)

[sunny_talwar]

So try this:

Avg({<Month>}Fraud score)

Sum({<Month>}Count)

[Anonymous · Accepted solution]

Avg({<Month=>}Fraud score)

Sum({<Month=>}Count)