Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
dineshm030
Creator III
Creator III

Set Analysis With Variable

Hi All,

I have created some text boxes based on the Cell Field Values. Below is the expression.

=Num(Sum(Aggr(If(Cell = 'Rosie 1', $(vOEE)),Cell)),'#,##0.00%')

Without Selection Cell Field Selection values are showing in all text boxes.

dineshm030_0-1623862183627.png

if i select one value from Cell field, selected value is showing in text boxes where as remaining its showing as 0.

dineshm030_1-1623862271753.png

My requirement is whatever value selected from Cell , all text boxes should be showing their corresponding values.

Kindly help me please.

Thanks in advance. 

Labels (1)
1 Solution

Accepted Solutions
MayilVahanan

Hi Dinesh,

Try like below

MayilVahanan_0-1623920285214.png

 

Num($(vAvailability($1)) * $(vPerformance($1)) * $(vQuality($1)),'#,##0.00%')

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

View solution in original post

8 Replies
MarcoWedel

maybe something like

Num(Sum({$<Cell={'Rosie 1'}>} $(vOEE)),'#,##0.00%')

 

what is the content of variable vOEE?

hope this helps

regards

Marco

dineshm030
Creator III
Creator III
Author

Hi Macro,

vOEE is

Num(If(Sum([Net Available]) <> 0, Sum(Running)/Sum([Net Available]), 0),'#,##0.00%') *

Num(If(Sum([Pieces per Minute]) * Sum(Running) <> 0, Sum([Actual Production (Pieces)])/(Sum([Pieces per Minute]*Running)),0),'#,##0.00%') *

Num(If(Sum([Actual Production (Pieces)] ) <> 0, (Sum([Actual Production (Pieces)]) - Sum(Reject))/Sum([Actual Production (Pieces)]),0),'#,##0.00%')

Note: I want to extract the particular value from the variable. But we can use set expression in the above formula.

Regards,

Dinesh 

MayilVahanan

HI Dinesh,

Change the vOEE  like below

Num(If(Sum({<$1>}[Net Available]) <> 0, Sum({<$1>}Running)/Sum({<$1>}[Net Available]), 0),'#,##0.00%') *

Num(If(Sum({<$1>}[Pieces per Minute]) * Sum({<$1>}Running) <> 0, Sum({<$1>}[Actual Production (Pieces)])/(Sum({<$1>}[Pieces per Minute]*Running)),0),'#,##0.00%') *

Num(If(Sum({<$1>}[Actual Production (Pieces)] ) <> 0, (Sum({<$1>}[Actual Production (Pieces)]) - Sum({<$1>}Reject))/Sum({<$1>}[Actual Production (Pieces)]),0),'#,##0.00%')

Try like below

=$(vOEE(Cell={'Rosie 1'}))

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
dineshm030
Creator III
Creator III
Author

Hi MayilVahanan,

I have tried your logic but its showing without any selection overall OEE.

dineshm030_0-1623912019420.png

If i Select the value from Cell as Rosie 1 both values are same it means for Rosie 2 showing same value.

Rosie 1 Text Box: =$(vOEE(Cell = {'Rosie 1'}))

Rosie 2 Text Box: =$(vOEE(Cell = {'Rosie 2'})) but the real value is 62.22% as given the above image.

Thanks & Regard,

Dinesh.

MayilVahanan

Hi Dinesh

Can you send  the sample file..

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
dineshm030
Creator III
Creator III
Author

Hi,

PFA...

Thanks in advance...

MayilVahanan

Hi Dinesh,

Try like below

MayilVahanan_0-1623920285214.png

 

Num($(vAvailability($1)) * $(vPerformance($1)) * $(vQuality($1)),'#,##0.00%')

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
dineshm030
Creator III
Creator III
Author

Hi MayilVahanan,

Its working fine.

dineshm030_0-1623940520501.png

Thanks & Regards,

Dinesh Kumar.