topic Re: set Analysis in QlikView

set Analysis

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

Hi All

I have few fields in the list box like subsystem,project,days, weekdays are fields based section of values in the fields the graph should display .

But will i am selecting the values

shows 252/252 (100%). Instead it should show the total of all the days it spent in all subsystems 252/488 (51.71%) ( where 488 is total if we didn’t select the subsystem).

can any one help me on this irrespective of the selection it should display total of the all days .

Re: set Analysis

trdandamudi — Wed, 16 Nov 2016 03:56:16 GMT

May be as below:

=num(SUM({<ir.status={'In Progress'}, ir.rma_days_open={">=$(days)"}>} metric.total_time)/SUM({ 1 <ir.status={'In Progress'}, ir.rma_days_open={">=$(days)"}>} total<ir.project> metric.total_time),'#.00%')

&chr(13)&

'('&num(SUM({<ir.status={'In Progress'}, ir.rma_days_open={">=$(days)"}>} metric.total_time),'0')&'/'&num(SUM({ 1 <ir.status={'In Progress'}, ir.rma_days_open={">=$(days)"}>} total<ir.project> metric.total_time),'0')&')'

Note: Added 1 in the expression with color coded.

Re: set Analysis

Anonymous — Wed, 16 Nov 2016 04:01:54 GMT

Hi Thirmula

Thanks for the fast response . if i passed the as you said it is calculating all the project and days . but my selection is only for particular project and days spent to that particular project

Re: set Analysis

trdandamudi — Wed, 16 Nov 2016 04:10:10 GMT

If you can,please share a sample app and the expected output....

Re: set Analysis

Anonymous — Wed, 16 Nov 2016 04:41:53 GMT

i Cant share the app the data around 1 Gb

Re: set Analysis

trdandamudi — Wed, 16 Nov 2016 04:59:43 GMT

Ok. Give a try with the below and see:

You said:

( where 488 is total if we didn’t select the subsystem).

=num(SUM({<ir.status={'In Progress'}, ir.rma_days_open={">=$(days)"}>} metric.total_time)/SUM({ <ir.status={'In Progress'}, subsystem=,ir.rma_days_open={">=$(days)"}>} total<ir.project> metric.total_time),'#.00%')

&chr(13)&

'('&num(SUM({<ir.status={'In Progress'}, ir.rma_days_open={">=$(days)"}>} metric.total_time),'0')&'/'&num(SUM({<ir.status={'In Progress'}, subsystem=,ir.rma_days_open={">=$(days)"}>} total<ir.project> metric.total_time),'0')&')'

Note: I removed 1 and included subsystem. If the field name is not subsystem then please modify accordingly.

Re: set Analysis

jonathandienst — Wed, 16 Nov 2016 05:25:51 GMT

This is much easier to analyse if you remove the decoration:

SUM({<ir.status={'In Progress'}, ir.rma_days_open={">=$(days)"}>}

metric.total_time)

SUM({<ir.status={'In Progress'}, ir.rma_days_open={">=$(days)"}>}

total <ir.project> metric.total_time)

The expression looks correct, but I expect your problem is the partial total. If ir.project is a dimension, then you will always get 100%, so either remove ir.project from the partial total (make into a normal full total, or partial by some other field(s)), or take ir.project out of the dimensions.

Once you have got the expression working, then you can reapply the decoration.

Re: set Analysis

Anonymous — Wed, 16 Nov 2016 05:55:55 GMT

Thanks so much Thirumala ,it worked perfectly

Re: set Analysis

trdandamudi — Wed, 16 Nov 2016 08:07:13 GMT

You are welcome and I am glad to hear that it worked....