lock down chart to only show data for a specific field value

[#1]

Hi all,

I have a traffic light chart that i only want to show for a certain field value and nothing else, so ignoring any other selection.

this is the current expression

=

IF($(vListing_Ratio)<=0.7,0,

IF($(vListing_Ratio)<1,0.5,1)) +

IF($(vVolume_Ratio)<=0.7,0,

IF($(vVolume_Ratio)<1,0.5,1))

and i want to include the logic for it to only report on the value 'ACCELERATE ABSOLUT; from the field 'it_objective_name'

Any help woulf be appreciated.

Thanks

[#2]

Well is not so clrear what you need, but if I understood weel, you should use Set Analisys for the specific criteria.

Hope this give you an idea to solve this!!

[#3]

Hi, i know i need to use set anaysis but i am unsure on the syntax used with all the IF statements in the expression i have quoted in the original question.

What i want it to use the above expression but include some set analysis which will ignore all selections apart from the value 'ACCELERATE ABSOLUT; from the field 'it_objective_name'

Thanks

[MayilVahanan]

HI

Can you explain the variable values?

Ex: try like this

where vListing_Ratio = sum(Sales) means for example, add like this

=Sum({< it_objective_name= {'ACCELERATE ABSOLUT'}>}Sales)

Hope it helps

[#5]

hi,

its a lot more complicated than that.

here is one of the variables..

the Listing_Ratio variable is made up of 2 other variables...

SET vListing_Ratio = $(vItemCount_Listings)/$(vTargetSum_Listings);

the 2 variables which are used in the above Listings_Ratio variable are.

LET vItemCount_Listings =

'COUNT({$<

[it_target_type]={"Listings"},

[ld_Dist]={"4"},

[ld_Outlet_Check_Date]={">='&CHR(36)&'($(vCurrentYearFiscalStartDate))"}

>}

[ld_Item_Description]

)';

LET vTargetSum_Listings =

'SUM({$<

[it_target_type]={"Listings"},

[ld_Dist]={"4"},

[ld_Outlet_Check_Date]={">='&CHR(36)&'($(vCurrentYearFiscalStartDate))"}

>}

[it_target_value]

)';

so as you can see, this is the reason i have used variables in the expressions.

[MayilVahanan]

HI

If you need only ACCELERATE ABSOLUT value means, you add set analysis in all the expression .

ex:

LET vItemCount_Listings =

'COUNT({$<

[it_target_type]={"Listings"},

[ld_Dist]={"4"},it_objective_name= {'ACCELERATE ABSOLUT'},

[ld_Outlet_Check_Date]={">='&CHR(36)&'($(vCurrentYearFiscalStartDate))"}

>}

[ld_Item_Description]

)';

LET vTargetSum_Listings =

'SUM({$<

[it_target_type]={"Listings"},

[ld_Dist]={"4"},it_objective_name= {'ACCELERATE ABSOLUT'},

[ld_Outlet_Check_Date]={">='&CHR(36)&'($(vCurrentYearFiscalStartDate))"}

>}

[it_target_value]

)';

hope it helps

[#7]

Have you considered to leave the chart just the way you have and decouple or dissociates the chart using the properties and decouple it??? just wondering.

[#8]

you mean detach it ?

i dont think thats the most efficient way. i want to do it properly and use the set analysis to lock it down

Thanks

[Gysbert_Wassenaar]

If you're using QV11 the easiest is probably to create a new alternate state, assing the new state to the chart and select ACCELERATE ABSOLUT in the field 'it_objective_name'. Maybe you need to temporarily add the field to the chart (you can remove it afterwards). Then right click on the field and click on Lock. That way you can't select another value in the field unless you unlock the field first.

[#10]

Hi, thanks for that suggestion, but i would prefer to use Set analysis as i have to do this on 6 charts all looking at different selections.

Does anyone know how to achieve this using set analysis please?

Many thanks