topic Re: User Driven Report in QlikView

User Driven Report

abhaysingh — Mon, 03 Nov 2014 06:13:18 GMT

hi all,

I have created user driven report in which I require to add AutoSum functionality like Excel.

Is it possible?

please help

Re: User Driven Report

vinay_hg — Mon, 03 Nov 2014 06:27:28 GMT

user driven report mean adhoc reports? then creat one more expression as metrix for auto sum

Re: User Driven Report

abhaysingh — Mon, 03 Nov 2014 06:44:31 GMT

yes Adhoc report,

how can I create metrix for auto sum??

Re: User Driven Report

jagan — Mon, 03 Nov 2014 06:56:03 GMT

Hi,

Check this link

Adhoc reporting in Qlikview

Hope it helps you.

Regards,

Jagan.

Re: User Driven Report

ashfaq_haseeb — Mon, 03 Nov 2014 06:58:57 GMT

Hi,

Check this

http://community.qlik.com/thread/140519

Regards

ASHFAQ

Re: User Driven Report

abhaysingh — Mon, 03 Nov 2014 07:04:51 GMT

hi jagan thanks for your feedback,

but I want to integrate it in Pivot table bcoz I need slice and dice feature as well.

Re: User Driven Report

jagan — Mon, 03 Nov 2014 07:25:08 GMT

Hi,

This works in Pivot table too, just convert Straight table to Pivot.

Regards,

jagan.

Re: User Driven Report

abhaysingh — Mon, 03 Nov 2014 07:30:28 GMT

No jagan I have check it is not showing totol sum in case of pivot table..

Re: User Driven Report

jagan — Mon, 03 Nov 2014 07:33:38 GMT

Hi,

Yes, you will get only Expression Sum, to overcome this you can try like this

Sum(Aggr(Sum(Measure), TableDim1, TableDim2,.....)

Hope this helps you.

Regards,

Jagan.