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: 
Not applicable

How to group the field in table box

Hi,

I used table box with productname,sales

product name , sales

soap 12

soap 8

powder 5

i need to group this value soap 20

powder 5

what should i have to done to show like this in tablebox.Any option to be checked in the table box properties

pls..help me out.Thanks in advance

1 Reply
Not applicable
Author

Hi

First you do script level

Load

Product_Name,

sum(Sales) as Sales

resoident Product group by Product_Name;

Then you call both field in table box.

Regards

Ashish