topic Calculate the Chart expression value based on input value in QlikView

Calculate the Chart expression value based on input value

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

Hi all,

I am trying to calculate productivity of the manpower based on shift using bar chart. However, i would like use to input box to input the number of people in each shift.

Example:

Data:

Part	Shift	Event
A	1	Finished
B	1	Finished
C	1	Finished
D	1	Finished
E	2	Finished
F	2	Finished
G	2	Finished
H	2	Finished
I	2	Finished
J	2	Finished

Input Box Variables:

Variables	Variable Value
Number of 1st shift people	5
Number of 2nd shift people	3

So,

Productivity of 1st shift people based on finished event time = 3/5 (number of finished events/number of people in 1st shift)

Productivity of 2nd shift people based on finished event time = 5/3 (number of finished events/number of people in 1st shift)

How do i calcuate this in expression because my number of people in shift changes everyday.

Thanks,

Vidya

Re: Calculate the Chart expression value based on input value

adityaakshaya — Thu, 03 May 2018 18:41:46 GMT

Hi Vidya,

vNoOfPeopleShift1 = data coming from input box

vNoOfPeopleShift2 = data coming from input box

Productivity of 1 shift = count({<Event = {'Finished'},shift = {1}>}Part)/$(vNoOfPeopleShift1)

Productivity of 2 shift = count({<Event = {'Finished'},shift = {2}>}Part)/$(vNoOfPeopleShift2)

Regards,

Akshaya

Re: Calculate the Chart expression value based on input value

poluvidyasagar — Thu, 03 May 2018 19:09:21 GMT

Hi Akshay,

Can this be achieved in one single expression? I want both expressions to be in one.

Thanks,

Vidya

Re: Calculate the Chart expression value based on input value

adityaakshaya — Thu, 03 May 2018 19:11:30 GMT

Hi Vidya,

We can do it one expression but can you help me to understand the use case. If you can tell me what exactly be the end result for you, I can write in one.

Regards,

Akshaya

Re: Calculate the Chart expression value based on input value

vishsaggi — Thu, 03 May 2018 19:32:39 GMT

How did you get Number 3 for 1st Shift people? I mean number of finished events based on data you provided?

Re: Calculate the Chart expression value based on input value

poluvidyasagar — Thu, 03 May 2018 19:34:38 GMT

Hi Akshay,

I want to display these results in one stacked bar chart showing productivity efficiency of the man power.

My dimensions are Date, Shift (i did not include date in the example data i gave)

My Measure is Productivity Efficiency.

Here is Sample: (Ignore numbers)

Let me know if this makes sense.

Thanks,

Vidya

Re: Calculate the Chart expression value based on input value

poluvidyasagar — Thu, 03 May 2018 19:40:47 GMT

Hi Vishwarath,

Yes, it is the number of finished events for each shift.

Thanks,

Vidya

Re: Calculate the Chart expression value based on input value

vishsaggi — Thu, 03 May 2018 20:03:35 GMT

We need more data to work on. can you share a sample file to look into?

Re: Calculate the Chart expression value based on input value

poluvidyasagar — Thu, 03 May 2018 20:27:42 GMT

Here is data:

Part	Date	Event	Shift
A	5/3/2018	Finished	1
B	5/3/2018	Finished	1
C	5/3/2018	Started	1
D	5/3/2018	Finished	2
E	5/3/2018	Finished	2
F	5/3/2018	Finished	2
G	5/3/2018	Finished	2
H	5/3/2018	Finished	2
I	5/2/2018	Started	1
J	5/2/2018	Finished	1
K	5/2/2018	Finished	2
L	5/2/2018	Finished	2
M	5/2/2018	Finished	2
N	5/1/2018	Finished	1
O	5/1/2018	Finished	1
P	5/1/2018	Finished	1
Q	5/1/2018	Finished	2
R	5/1/2018	Finished	2
S	5/1/2018	Finished	2
T	5/1/2018	Finished	2

Variables:

Variables	Variable Value
Number of 1st shift people	5
Number of 2nd shift people	3

Let me know if this helps

THanks,

Vidya

Re: Calculate the Chart expression value based on input value

adityaakshaya — Thu, 03 May 2018 20:30:39 GMT

Hi Vidya,

Please find below the expression for your chart.

if(Shift = '1st',count({<Event = {'Finished'}>}Part)/$(vNoOfPeopleShift1),

if(Shift = '2nd',count({<Event = {'Finished'}>}Part)/$(vNoOfPeopleShift2),

count({<Event = {'Finished'}>}Part)/$(vNoOfPeopleShift3)))

Here above you have to create 3 variables for three shift

vNoOfPeopleShift1, vNoOfPeopleShift2, vNoOfPeopleShift3

Regards,

Akshaya

PS - If you find this response correct, mark it as correct.

Re: Calculate the Chart expression value based on input value

vishsaggi — Fri, 04 May 2018 14:05:57 GMT

Try this?

Add Dim:

Date

Shift

Expr:

= Pick(Shift, Count({< Event = {'Finished'}>} Part)/$(vShift1People),
Count({< Event = {'Finished'}>} Part)/$(vShift2People))

Re: Calculate the Chart expression value based on input value

vishsaggi — Mon, 21 May 2018 14:25:50 GMT

Did you get what you are looking for?