topic Data value not affected by filters in QlikView

Data value not affected by filters

Thu, 22 Jan 2015 10:49:58 GMT

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

Re: Data value not affected by filters

Thu, 22 Jan 2015 10:52:44 GMT

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

Re: Data value not affected by filters

PrashantSangle — Thu, 22 Jan 2015 10:53:38 GMT

Hi,

try like

Sum(Total<Year> turnover)

Regards

Re: Data value not affected by filters

Thu, 22 Jan 2015 11:01:29 GMT

Thanks Joe.

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

Regards

Re: Data value not affected by filters

tyagishaila — Thu, 22 Jan 2015 11:10:35 GMT

Try this

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

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

Let me know