Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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