topic Re: dynamic Expression in QlikView

dynamic Expression

nareshthavidishetty — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: dynamic Expression

jyothish8807 — Thu, 03 Nov 2016 06:28:43 GMT

Hi Naresh,

Try like this:

Dim: Process

expression:

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

Br,

Re: dynamic Expression

nareshthavidishetty — Thu, 03 Nov 2016 06:38:51 GMT

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

Re: dynamic Expression

Anil_Babu_Samineni — Thu, 03 Nov 2016 06:45:21 GMT

Share your Application?

Re: dynamic Expression

nareshthavidishetty — Thu, 03 Nov 2016 06:50:54 GMT

cannot share the application nda

if u want I can provide more details

Re: dynamic Expression

Anil_Babu_Samineni — Thu, 03 Nov 2016 06:56:22 GMT

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

Re: dynamic Expression

Thu, 03 Nov 2016 06:59:13 GMT

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

Re: dynamic Expression

jyothish8807 — Thu, 03 Nov 2016 06:59:43 GMT

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

Re: dynamic Expression

nareshthavidishetty — Thu, 03 Nov 2016 07:03:55 GMT

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%

Re: dynamic Expression

jyothish8807 — Thu, 03 Nov 2016 07:09:21 GMT

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,

Re: dynamic Expression

nareshthavidishetty — Thu, 03 Nov 2016 07:17:19 GMT

I got like 24 or 25 process and I cannot wrte for each process as it should be dynamic might be client changes that threshold value to 99% or 100% in the future so it should be dynamic

all I want is depending on the process that percentages should be shown but here there are not constant ,

when calculating the Quality% values may be 98% or 99% or 95%

I want to shown color coding depending on the process level like for X process it is 98% if it goes to 97.5% or what ever less it is red in color

like that for other process threshold value is 95% and if it goes less I want to show red in color

Re: dynamic Expression

Anil_Babu_Samineni — Thu, 03 Nov 2016 07:17:34 GMT

If your expression good, And if you want to % as well while hit filtering you may try this.

And you mentioned the % is not showing after selection, Does this you are referring?

1) You can use % Symbol from Number Format

Re: dynamic Expression

nareshthavidishetty — Thu, 03 Nov 2016 07:36:57 GMT

I got like 24 or 25 process process and I'm calculating Quality % what I have provided above , based on client they provided some threshold values like 98% or 99% for processes

now if I select process X and its threshold value is 98% or greater than 98% it should show green or else red if values are less than 98% like that for some other process it is 95% it should show red or green if it goes below or above how can I achieve this in straight table or any other

Re: dynamic Expression

jyothish8807 — Thu, 03 Nov 2016 07:46:08 GMT

Hi Naresh,

Try like this:

in Background color. You can write nested if for all process or you can write pick match.

If(Process='X' and

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) <98%,red(),green())

Br,

Re: dynamic Expression

jyothish8807 — Thu, 03 Nov 2016 07:52:33 GMT

to make it more easy, make a inline table with process and threshold value.

process Threshhold

x 98%

y 98%

z 95%

a 95%

b 95%

c 98%

Now in background expression:

if(

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) <Threshhold,red(),green())

Br,

Re: dynamic Expression

nareshthavidishetty — Thu, 03 Nov 2016 09:08:10 GMT

not working

Re: dynamic Expression

jyothish8807 — Thu, 03 Nov 2016 09:12:05 GMT

Make suer the 'Process field' inline table and "Process Field" used in chart have an association in data model.

Attached an sample.

Regards

Re: dynamic Expression

nareshthavidishetty — Thu, 03 Nov 2016 10:56:03 GMT

this is not what I'm looking i calculated the quality percentage in the straight table by below formula

for the calculation Quality%

and formula is correct for the Quality% I'm jus showing quality% in straight table by using this formula,now my question color coding depending on the process, I'm showing red ,green colors accordingly because value is only 1 here that is 99% (threshold value) so i written a condition in express backgrd <0.99

in some cases it is only 0.95 or 95% for some process in 24 processes,

so how can i achieve when that changes