topic Re: Total and filters in QlikView

Total and filters

Tue, 07 Apr 2015 09:57:05 GMT

Hello!

that is my table:

I need to obtain the total I've put in field "R_T" as follows:

If(COD=9937199,Sum({<COD={9937199},TIME=>}AD)-vSumT9937302,

if(COD=9937072,Sum({<COD={9937072},TIME=>}IN),Sum({<TIME=>}AD)))

And R:

If(COD=9937199,Sum({<COD={9937199}>}AD)-vSum9937302,

if(COD=9937072,sum(IN),sum(AD)))

My variable:

vSumT9937302=Sum({<COD={9937302},TIME=>}AD)

vSum9937302=Sum({<COD={9937302}>}AD)

In R gets all filters and R_T not take the filter TIME because I want the total always displayed.

The problem is that when a COD does not have data in TIME, in this case, COD 9937072 does not have data in TIME "3" so when I filter TIME 3 does not give the total correctly.

How I can fix that? I want to see total every time

I attached file. Thanks!!

Re: Total and filters

pokassov — Tue, 07 Apr 2015 10:11:00 GMT

Hi!

I fixed it. See expression R_T2

Re: Total and filters

Tue, 07 Apr 2015 10:46:06 GMT

Hi! thanks!

And if the COD of the variable has the same situation:

What is the code for the variable vSumT9937302 to show always the total?
Thank you!

Re: Total and filters

pokassov — Tue, 07 Apr 2015 10:57:47 GMT

As I see we exclude TIME in the Set Analysis. So vSumT9937302 always ignores selection on TIME.

Or I didn't get your question...

Re: Total and filters

Tue, 07 Apr 2015 11:22:31 GMT

You're right! Everything it's ok.

Thank you very much!