topic Re: In straight table in QlikView

In straight table

Fri, 26 Sep 2014 15:30:00 GMT

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

Re: In straight table

Fri, 26 Sep 2014 15:37:45 GMT

Hi,

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

Hope this will work.

Regards,

Joshmi

Re: In straight table

sathishkumar_go — Fri, 26 Sep 2014 15:39:09 GMT

HI Subbu,

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

-Sathish

Re: In straight table

Fri, 26 Sep 2014 15:45:45 GMT

Thq sir it's working

Re: In straight table

Fri, 26 Sep 2014 15:52:42 GMT

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

Re: In straight table

sathishkumar_go — Fri, 26 Sep 2014 16:24:32 GMT

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

just select No Totals

-Sathish

Re: In straight table

sathishkumar_go — Wed, 01 Oct 2014 16:10:55 GMT

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

Re: In straight table

Mon, 02 Feb 2015 11:27:39 GMT

Hi,

Please find the attachment !`