In DrillDown Group, based on the dimension the expression should change

[#1]

Dear QV Experts,

I have two columns in CyclicGroup Dimension.

Now If selected the first column, FinYear, the expression should display in Percent

If selected the second column [means drill down], the expression should display in Value.

Please find enclosed the QVW & Input file.

If AbsFinYear, Currently it is displaying the Value. But it should display the percent [4.11% , 2.90%, 4.17% respectively for the years] from the input file.

When drilldown, it should display the value, which is correct.

Can you please suggest me on this issue.

Thanks for your prompt response.

Sasi

[#2]

Also i tried like this in Expression,

if(GetCurrentField('EAP Utilisation Rate') = 'Dept', Sum(Data1),Sum(W)),  The chart look like below,

Here 2012-13 should display as 4.11% & if i drilldown the A, B, C ... should display Sum(Data1).

Please suggest me on this.

Sasi

[#3 · Accepted solution]

there are a couple of items you will need to address.  first you will need 2 expressions - one for percent and the other for the count.

Once each expression is defined, you will then want to make them conditional - the percent will be displayed when there are no selections made.  The count will be displayed when the absfinyear has been selected.  You can use

GetSelectedCount (absfinyear) > 0 and for the percent use GetSelectedCount (absfinyear) = 0 as the condition

[#4]

Dear Adam,

I tried having two expressions [one for Percent, the other for value)

Modified the expression based on your suggestion, it is working as expected.

Please find enclosed the updated version. Thanks a lot.

Sasi