topic Re: Expression Totals On Row in QlikView

Expression Totals On Row

khaycock — Wed, 25 Nov 2020 16:16:04 GMT

Hey,

Is it possible to have the highlighted expressions amount positioned underneath the amount, so where it says total now?

I'm not sure if it is something you can actually do on QlikView?

I think it would look better than having the extra columns.

Thanks!

Re: Expression Totals On Row

sunny_talwar — Tue, 14 Feb 2017 12:07:35 GMT

I don't think there is any direct way to do this. There might be some work around, but will have to be tested out

Re: Expression Totals On Row

vinieme12 — Tue, 14 Feb 2017 12:17:01 GMT

have you tried checking the Indentation Option on Style tab?? with a pivot table

Re: Expression Totals On Row

khaycock — Tue, 14 Feb 2017 12:22:59 GMT

Goes all funny and repeats everything, ideally I want to be able to get rid of the expression columns

Re: Expression Totals On Row

vinieme12 — Tue, 14 Feb 2017 12:44:24 GMT

can you post a sample app?

Preparing examples for Upload - Reduction and Data Scrambling

Re: Expression Totals On Row

khaycock — Tue, 14 Feb 2017 16:04:38 GMT

Here you go

Re: Expression Totals On Row

vinieme12 — Wed, 15 Feb 2017 05:08:27 GMT

Check the attached, look at the expressions

Re: Expression Totals On Row

khaycock — Wed, 15 Feb 2017 11:59:36 GMT

Its changed the format on the white column from number to currency though

Re: Expression Totals On Row

vinieme12 — Wed, 15 Feb 2017 12:01:29 GMT

You can Fix the formatting with NUM() function directly in the expression and Change formatting setting in Number tab to Expression Default

Let me know if you need help

Re: Expression Totals On Row

khaycock — Wed, 15 Feb 2017 12:12:50 GMT

But the count is the white part which needs to be a number and the grey part underneath is the cost which needs to be in £. When changing the expression it changes the whole column. Is there a way to make them different?

Re: Expression Totals On Row

vinieme12 — Wed, 15 Feb 2017 12:19:33 GMT

See attached

example:

=if(RowNo()=0,

num([Over pack per drop >5]*0.53,'£ ##,###')

,num([Over pack per drop >5]))

Re: Expression Totals On Row

khaycock — Wed, 15 Feb 2017 12:29:58 GMT

Didnt work, the amount is still coming up as £

Re: Expression Totals On Row

Wed, 15 Feb 2017 12:57:58 GMT

Go for custom format cell option to color it

Re: Expression Totals On Row

vinieme12 — Wed, 15 Feb 2017 17:58:59 GMT

Which one?? Have you checked the app , you need to set formatting to expression default for all expressions ? Please change the num formatting in each expression as you want it to be

Re: Expression Totals On Row

khaycock — Thu, 16 Feb 2017 09:55:01 GMT

Ah sorry didn't see you had attached the file with it! Thanks thats amazing

Re: Expression Totals On Row

khaycock — Thu, 02 Mar 2017 10:08:23 GMT

Is there anyway I can add a total column to sum up just the costs on the right?