topic set analysis - in QlikView

set analysis -

Wed, 14 Mar 2012 17:25:11 GMT

Hello,

I´d like to know, if is possible to join 2 set expressions (below) together in one expression.

The expresions are:

1. sum ({1<Field_X={Budget}>} Value)

2. sum ({$<Project_Name>} Value)

I need to show value of Budget (full set of all the records) together with Project_Name (the records of the current selection)

It should be used in a bar chart where I want to display sum of Budget for whole year independently of current selection of months and simultaneously the budget should change with a selection of type of Project_Name.

Is any different way to solve this problem?

Thanks

set analysis -

Wed, 14 Mar 2012 17:38:06 GMT

I found one error - corrected and marked with Bold

Hello,

I´d like to know, if is possible to join 2 set expressions (below) together in one expression.

The expresions are:

1. sum ({1<Field_X={Budget}>} Value)

2. sum ({$<Project_Name>} Value)

I need to show value of Budget (full set of all the records) together with Project_Name (the records of the current selection)

Is any different way to solve this problem?

Thanks

set analysis -

Thu, 15 Mar 2012 11:15:03 GMT

Hi,

try following:

Sum( {<AnyField=, Field_X={Budget} >} Value)

This would for Sum ignore every selection made over the field “AnyField”

set analysis -

CELAMBARASAN — Thu, 15 Mar 2012 11:44:58 GMT

Hi,

Check with this

sum ({<YearField=,MonthField=,Field_X={Budget}>} Value)

Celambarasan

set analysis -

Tue, 20 Mar 2012 09:39:36 GMT

Thank you very much,

it works greatly