Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
lakshmanvepuri
Creator
Creator

Values to breakup in Chart / Table

Hi all,

I am getting this Result.

 

lakshmanvepuri_1-1617385256621.png

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

lakshmanvepuri_2-1617385299350.png

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

 

2 Replies
Igoresz
Contributor II
Contributor II

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)) 👍😉

who thinks about cells, not tables.PNGwho thinks about cells, not tables2.PNGwho thinks about cells, not tables3.PNGwho thinks about cells, not tables4.PNG

lakshmanvepuri
Creator
Creator
Author

Hi @Igoresz ,

 

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