conditional shows with set analysis and variables

Anonymous — Fri, 04 Sep 2015 14:57:29 GMT

Hello,

I'm having an issue using set analysis in a list box to show selections based upon a variable.

What's happening is I have 3 buttons for Volumes, Cost, and Profits. These buttons control 2 variables (vCostList, vProfitList) and I'm using these variables to show which selections are possible (The selections make columns show in a table)

Everything works correctly except for when vProfitList is 1 and vCostList is 0. When this happens the %MeasureGroup Volumes will show, but Profit will not.

I have pasted my code below. Any help is greatly appreciated.

=	if(vProfitList = 1 and vCostList = 1,
	AGGR(
		ONLY({1}
			if(len(trim(%MeasureGroup))>1, %MeasureGroup & '\','') & %Measure
		)
		,%Measure
	),
		if(vProfitList = 1 and vCostList = 0,
			AGGR(
		ONLY({1}{$<%MeasureGroup = {'Volumes','Profit'}>}
			if(len(trim(%MeasureGroup))>1, %MeasureGroup & '\','') & %Measure
		)
		,%Measure
	),
		if(vProfitList = 0 and vCostList = 1,
			AGGR(
		ONLY({1}{<%MeasureGroup = {'Volumes','Cost'}>}
			if(len(trim(%MeasureGroup))>1, %MeasureGroup & '\','') & %Measure
		)
		,%Measure
	))))

Re: conditional shows with set analysis and variables

sasiparupudi1 — Fri, 04 Sep 2015 19:33:33 GMT

Try putting the following in a text box and see if it returns any value

if(vProfitList = 1 and vCostList = 0,

AGGR(

ONLY({1}{$<%MeasureGroup = {'Profit'}>}

if(len(trim(%MeasureGroup))>1, %MeasureGroup & '\','') & %Measure

)

,%Measure

hth

Sasi

topic Re: conditional shows with set analysis and variables in QlikView

conditional shows with set analysis and variables

Re: conditional shows with set analysis and variables