topic Values to breakup in Chart / Table in QlikView

Values to breakup in Chart / Table

lakshmanvepuri — Fri, 02 Apr 2021 17:47:24 GMT

Hi all,

I am getting this Result.

From here, Need to enable the result to show the given way.

Please find the enclosed attachment for deriving the specific Result.

0- 12 hrs Performance ( 12hr)

0-24 hrs Performance ( 12hr+24hr )

0-48 hrs Performance (12hr+24hr+48hr)

no need to show >48 hr performance ... but it should consider in % in Performance and total Quantity.

Thanks

Vepuri

Igoresz — Sat, 03 Apr 2021 16:04:31 GMT

Hello, Lakshman.

If you need additional groups,so create it in your model, use

Load Inline[hr_group,hr

...

0-24 hrs Perf, 24hr
0-24 hrs Perf, 12hr
0- 12 hrs Perf, 12hr

] in your script
Expression (%) in your green table looks like Sum (value)/Sum (Total <Perf> value)) 👍😉

lakshmanvepuri — Sat, 03 Apr 2021 15:45:50 GMT

Tried the same, but not getting the result as expected.

Please help to take the input given and upload the sample qvw file.

Thanks

Lakshman