Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
sunitha_chellaiah
Partner - Creator
Partner - Creator

scripting

Hi All,

I want to get below output using backend  scripting.

Please use attached data to get the output.

Thanks.

11 Replies
jonathandienst
Partner - Champion III
Partner - Champion III

May i ask why? It is possible, but the app will not respond in useful ways to user selections.

If you want partial totals, then a pivot table is the object to use. There are no subtotal in a straight table.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Sergey_Shuklin
Specialist
Specialist

Hello, Sunitha!

Exactly as your output is:

simple_straight.png

All calculations are done in the script.

PFA.