Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ MORE
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.