Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
dineshm030
Creator II
Creator II

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

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 II
Creator II
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
dineshm030
Creator II
Creator II
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
dineshm030
Creator II
Creator II
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

View solution in original post

dineshm030
Creator II
Creator II
Author

Hi MayilVahanan,

Its working fine.

dineshm030_0-1623940520501.png

Thanks & Regards,

Dinesh Kumar.