dynamic Expression

[nareshthavidishetty]

Hi all ,

I got a requirement like there are process and Quality check

process       Quality check threshold will be

x                      98%

y                      98%

z                      95%

a                       95%

b                       95%

c                       98%

so I'm showing that in straight table these things   now my question is

if I select process x,or y or c it should show 98% dynamically

and if I select z it should show 95%

how can I achieve this

I can write a condition in expression(background color)    if it is only 98% but here it is changing to 98 or 95

[jyothish8807]

Hi Naresh,

Try like this:

Dim: Process

expression:

Count([Quality check] / count({1}total [Quality check])

Br,

KC

[nareshthavidishetty]

Hi I'm not counting here I want that 98% or 95% should be shown if I select process x,y but here threshold values are consistent they are changing on process level

[Anil_Babu_Samineni]

Share your Application?

[nareshthavidishetty]

hi

cannot share the application nda

if u want I can provide more details

[Anil_Babu_Samineni]

Application, Means not the real directory Data. Try to create scramble data. This also not possible

Can i know what expression you are using this Quality check threshold will be

[#7]

Hi Naresh ,

I did not get the exact requirement but its better if you store these values in a variable , so that the they are not affected by a change in selection .

Hope this helps .

Regards,

Shantanu

[jyothish8807]

Hi Naresh,

Then Try expression like below:

if(Process='X','98%',if(Process='Y','98%'))

Is this what you are looking for. Now the values will be constant for each process.

Regards

KC

[nareshthavidishetty]

sum({<Activity={Quality Check},Year={$(vCurrYear)},Month={$(vCurrMonth)}>}No_Of_Items)-(sum({<Activity={External error},Year={$(vCurrYear)},Month={$(vCurrMonth)}>}No_Of_Items)))/sum({<Activity={Quality Check},Year={$(vCurrYear)},Month={$(vCurrMonth)}>} No_Of_Items)

for the calculation Quality%

[jyothish8807]

Hi Naresh,

Your requirement is not clear.

Its obvious that if the threshold value changes then the expression value will also change.

Try this also.

sum({<Activity={Quality Check},Year={$(vCurrYear)},Month={$(vCurrMonth)}>}No_Of_Items)-(sum({<Activity={External error},Year={$(vCurrYear)},Month={$(vCurrMonth)}>}No_Of_Items)))

/

sum({1<Activity={Quality Check},Year={$(vCurrYear)},Month={$(vCurrMonth)}>}total No_Of_Items)

Br,

KC