topic Re: Expression Total & Dimension Limits in QlikView

Expression Total & Dimension Limits

edg_baltazar — Mon, 04 Nov 2013 23:31:03 GMT

Hi ALL!

I've developed some report using a Straight Table , the main idea is to show the list of partners that make the sales percentage that you select on a Slider Object, It seems to work as I expected the only Issue that I can't solve is the TOTAL on a column where I show the Quarter over Quarter Growth Percentage because it always show the total Growth even If I'm filtering the list of partners that make the 10% of the sales or any other percentage distinct to 100% , I suspect that this is because the total mode that I selected for this expressions is 'Expression TOTAL' and this do not take on count the Dimension Limits that is what Im using to display the list of clients according to the percentage on the slider...

Do you know if is there something that I could do to solve this?

Please see the attached images and the sample .QVW

Best Regards!

Selecting 100% of the Sales...

Selecting 50% of the Sales... same QoQ Growth!

Selecting 10% of the Sales... same QoQ Growth!

Re: Expression Total & Dimension Limits

Tue, 05 Nov 2013 00:31:00 GMT

Something like this?

In the expression of QoQ i just changed the "Expression Total" for "Sum of Rows"

Best Regards!!

Re: Expression Total & Dimension Limits

jonathandienst — Tue, 05 Nov 2013 05:53:29 GMT

Perhaps you should use column arithmetic here. Then the total calculation will use the total values from each column.

QoQ = (Column(2) - Column(1)) / Column(1)

QoQ = ([Q2] - [Q1]) / [Q1] // column names

HTH

Jonathan

Re: Expression Total & Dimension Limits

edg_baltazar — Tue, 05 Nov 2013 18:20:19 GMT

Hi Jonathan! , thanks for your response !

Even using the columns or columns names in the expression this doesn't work because it still shows the total Growth as if I have selected 100% in the slider object when I have selected the 50%....

Look at the next image... in that case my expected number is ....(1100/450)-1 = 144.44 % of Growth.

Best Regards !

Re: Expression Total & Dimension Limits

Thu, 07 Nov 2013 23:29:41 GMT

mine works :C

Re: Expression Total & Dimension Limits

christian77 — Fri, 08 Nov 2013 13:25:18 GMT

Hi.

There is another way to control what's in the total.

In your expression say:

if( Dimenssionality()=0, your total expression, your regular expression)

You can set only Dimensionality() and see how it acts.

This way you can place whatever you want in the total cell.

Salutes.

Re: Expression Total & Dimension Limits

edg_baltazar — Fri, 08 Nov 2013 18:00:47 GMT

Hi Raúl ,

Thanks for your answer but this is not exactly what I'm looking for , because suming the percentajes is not going to retreive me the correct total growth.

Regards!

Re: Expression Total & Dimension Limits

edg_baltazar — Fri, 08 Nov 2013 18:03:47 GMT

Hi Christian ! thanks for your answer ,

I've already tried this in the past , but the thing is that neither way the total expression does not respect the Dimension Limits behaivor.

Best Regards!

Re: Expression Total & Dimension Limits

Fri, 08 Nov 2013 18:46:44 GMT

Lo que quieres es que se muestre el porcentaje que pones en el slider en el total de la columna QoQ?

Re: Expression Total & Dimension Limits

billbois — Wed, 08 Oct 2014 20:05:20 GMT

I realize it's been 11 months since the last post, but was a solution ever found? I'm having the same issue now.