topic Re: Set analysis to compare one field value with another in QlikView

Set analysis to compare one field value with another

Tue, 03 Sep 2013 13:29:20 GMT

Hi Folks,

I've a small requirement to write set analysis expression to get the values by comparing one field value with another.

For the fields country_id,year_id,measure_id,scenario_id I need to derive the measure based on the measure_value.

eg: for Country=25,year=11,measure=32,scenario=1,2,3 the applicable scenario is 1 . Hence the derived measure value should be 12 which is the measure value for scenario 1.

Similarly for country=25,year=114,measure=32,scenario=1,2,3 the applicable scenario is 2. Hence the derived measure value should be 27 which is the measure value for scenario2.

Can any one help me to write the expression to derive the measure.

Thanks,

Surendra

Re: Set analysis to compare one field value with another

Tue, 03 Sep 2013 13:37:22 GMT

I think It should be:

Only({<scenario={$(Only([Applicable Scenario]))}>}TOTAL<scenario> measure_value)

Where your dimensions should be:

Country, Year, measure and scenario.

Anyway, I think it would be better choice to calculate that field in the script.

Re: Set analysis to compare one field value with another

Tue, 03 Sep 2013 13:53:13 GMT

No IOSU,

The expression didn't return any thing.

Thanks,

Surendra

Re: Set analysis to compare one field value with another

Tue, 03 Sep 2013 14:04:32 GMT

My fault. It was:

Only({<scenario={$(=Max([Applicable Scenario]))}>}TOTAL<country, year, measure> measure_value)

Re: Set analysis to compare one field value with another

Tue, 03 Sep 2013 14:09:02 GMT

PFA: