topic Re: Ignore all selections when sum fields in QlikView

Ignore all selections when sum fields

Thu, 28 May 2015 01:15:50 GMT

Hello,

I have got an expression in a textbox that consists of the following...

day(Field1+field2)/2

But it only works if I select one of the 2 fields, is the way to ignore the selections?

I could use set analysis but I am only use to use it when doing a proper aggregations.

Thanks for you help.

Re: Ignore all selections when sum fields

Anonymous — Thu, 28 May 2015 01:59:51 GMT

It's not clear what you want to see in the text box...

This expression can return a result only in both Field1 and field2 have only one value selected (available). If more than one value, the result will be null, exactly because there is no aggregation. This expression will return a result, given the sum of the parts can be interpreted as a date:

day(avg(Field1)+ avg(field2))/2

But I can't guess if this is what you need

Re: Ignore all selections when sum fields

Thu, 28 May 2015 02:01:25 GMT

Please elaborate more. I could not able to understand what exactly you are expecting.

Regards,

Uday.

Re: Ignore all selections when sum fields

Thu, 28 May 2015 02:08:58 GMT

I want a KPI of AVG day (in the text box) and to be shown without selection of the dimention. .