Data value not affected by filters

[#1]

Dear All,

I am new on Qlikview and I am testing the trial version of QV11.

I have 5 excel files which contains data on turnover split by months. Each excel file refers to a specific year.

I can select the month and year and see which is the specific turnover in that period. So far so good.

Now, I would like to compare the filtered data of each month with the total turnover for a specific year. The problem is that also the total turnover is affected by my month selection.

Is there any way to have a specific field which QV populates with data from an excel table and which value remains unchanged even if I filters the data of the same table? This can help me to compare a specific period of each year with the total amount of that year.

I tried to surf on the web and this community without success.

Thank you for your help

Massimo

[#2]

Hi Massimo,

you will most likely use set analysis to achieve this, have a look at the below for more on the topic

http://community.qlik.com/docs/DOC-4951

hope that helps

Joe

[PrashantSangle]

Hi,

try like

Sum(Total<Year> turnover)

Regards

[#4]

Thanks Joe.

It seems very helpful. Let me have a deep look.

Regards

[tyagishaila]

Try this

Sum({$<month>}turnover) for current selection of month.

Sum({1<year='2014'>}turnover) for total turnover of year

Let me know