topic Re: is there a way in QlikView

is there a way

ali_hijazi — Mon, 28 Nov 2016 14:07:44 GMT

Hello

is there a way to let users choose between showing totals and hiding them?

Re: is there a way

sunny_talwar — Mon, 28 Nov 2016 14:12:43 GMT

I think this should be possible. Do you have a particular example where we can play around with it?

Re: is there a way

jpenuliar — Mon, 28 Nov 2016 14:15:14 GMT

Hi Ali,

Have a look at QlikView How To (or Tips & Tricks) Application by Lee Matthews

http://community.qlik.com/docs/DOC-5486

You can make use of "Conditional" poroperty of chart expressions to Show or hide values.

Re: is there a way

jeckstein — Mon, 28 Nov 2016 14:16:01 GMT

There is no way to toggle totals on/off in Qlik sense. You can only do something like that for the title.

You can have users use the page editor (but this is not recommended).

Re: is there a way

Miguel_Angel_Baeyens — Mon, 28 Nov 2016 14:17:09 GMT

There is, indeed, as they can right click on the object and select themselves, but that might not be what you want to use.

For me, the quickest solution would be to replicate those objects in a different sheet which looks like the same (i.e: same menus) but the totals are not there. And you can get to these "no-totals" sheets with a button in your menu, or clicking on a text object or something similar.

Re: is there a way

jeckstein — Mon, 28 Nov 2016 14:29:35 GMT

Can you explain what you mean by "they can right click on the object and select themselves"?.

Re: is there a way

Miguel_Angel_Baeyens — Mon, 28 Nov 2016 14:37:25 GMT

I mean use the object properties (right click) to show/hide totals, if you allow them to do that.

EDIT: Ajax client: right click on the chart > Properties > Expressions > More > Use Expression Total > No Totals

Re: is there a way

el_aprendiz111 — Mon, 28 Nov 2016 20:20:54 GMT

Hi,

this can serve you:

Pivot table show/hide subtotal by macro.

Re: is there a way

sunny_talwar — Tue, 29 Nov 2016 00:09:17 GMT

Showing total

Totals hidden

Expression used

=If(vToggle, Sum(Sales), Aggr(Sum(Sales), Year, Month))

'Show Partial Sums' are on for both Year and Month field

Hope this is what you are looking for.

Best,

Sunny