topic Re: Set Analysis Question in QlikView

Set Analysis Question

Mon, 04 Aug 2014 11:37:11 GMT

Hi Everyone

Please can someone help me with this:

I need to keep this static .i.e does not change with the current selection:

sum(TOTAL GArevenue)

GArevenue changes with the current selection.

Thanks

Vaneshan Naidoo

Re: Set Analysis Question

senpradip007 — Mon, 04 Aug 2014 11:39:13 GMT

Try like

sum({1} TOTAL GArevenue)

Re: Set Analysis Question

Mon, 04 Aug 2014 11:45:37 GMT

Hi Pradip

Nope, I tried that - doesn't work. It inflates the TOTAL to much higher the an the true value.

Re: Set Analysis Question

ashfaq_haseeb — Mon, 04 Aug 2014 11:55:04 GMT

Hi,

Try below

sum({<YourMonthField>}TOTAL GArevenue)

Add all dimension you don't want filtering

Regards

ASHFAQ

Re: Set Analysis Question

Mon, 04 Aug 2014 11:56:08 GMT

Hi,

Then exclude only the fields which you do not want the expression to get affected.

Example:

If you do not want Selection in the field Country to effect you expression then use:

sum({<Country=>} TOTAL GArevenue)

Re: Set Analysis Question

senpradip007 — Mon, 04 Aug 2014 11:57:57 GMT

Could you upload your sample qvw?

Re: Set Analysis Question

aveeeeeee7en — Mon, 04 Aug 2014 12:02:24 GMT

You can By pass the Selections like this:

1. sum(TOTAL{Field1=,field2=} GArevenue)

2. Sum(Total <FieldName=> GArevenue)

3. Sum(Total <FieldName1,Fieldname2> GArevenue)

Regards

Aviral Nag

Re: Set Analysis Question

Mon, 04 Aug 2014 12:10:16 GMT

Hi,

It still doesn't work, the problem is that GArevenue changes as selections are made.

The full expression is :

sum(GArevenue)/sum(TOTAL GArevenue)

When I click on anything in the front end, it changes the value of Sum(GArevenue) which is fine BUT is don't want to TOTAL sum(GArevenue) to change as this is used to calc the % proportions.