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

Announcements
Qlik Connect 2026 Agenda Now Available: Explore Sessions
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

In straight table

hi friend's this is subbu in my straight has 2001, 2002,2003, 2004 data like this

budget year      budget rev

2001                 10000

2001                 20000

2002                 30000

2002                 40000

2003                10000

2003                30500

2004               10000

2004               20000

so i want in straight table

year     budget rev

2001  (2001 sum data)

2002  (2002 sum data)

2003  (2003 sum data)

2004  (2004 sum data)  please tell me any one

7 Replies
Not applicable
Author

Hi,

Give Budget Year in dimension and sum(budget data) in expression.

Hope this will work.

Regards,

Joshmi


sathishkumar_go
Partner - Specialist
Partner - Specialist

HI Subbu,

just pass dimension "Budget Year" and Expression - SUM(budget revenue)

-Sathish

Not applicable
Author

Thq sir it's working

Not applicable
Author

hi sir i   don't want  display the totals in straight table  how to remove total values in straight table could u tell me sir

sathishkumar_go
Partner - Specialist
Partner - Specialist

Go to expression tab-> Right side you can able to find Total mode

just select No Totals

-Sathish

sathishkumar_go
Partner - Specialist
Partner - Specialist

Hi,

Please close this thread for providing the Helpful or correct answer. This will help others to search the community with same kind of issues.

-Sathish

Not applicable
Author

Hi,

Please find the attachment !`