Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Re: Creating a value to show the % participation

I´m using this, but the result is the same(got the same values):

=sum(Real)/(Sum(total<Month>{$<[Cuenta Resu]={'Sales'}>} Real))


Thanks

Highlighted
MVP
MVP

Creating a value to show the % participation

Just to be sure, 'Month' is your month field name? Because every field else is named in spanish...

Could you post a small sample application here?

Highlighted
Contributor III
Contributor III

Re: Creating a value to show the % participation

You are right I translated some words trying to make it more understandable Month is my Month field name, the exact line right now is:

=sum(Real)/(Sum( total{$<[Cuenta Resu]={'Ventas'}>} Real))

This line gives me the Sales participation percentage of every line and works fine when I have the information agregated.

Now I would like to use the variable Month to separate de data on Months columns. I did this and it looks fine but a closer look you can see that the sales (and all the other fields separated by moths) are being divided by the total sales not just the month sales wich result on a smaller participation % than what should be.

I´m attaching a sample app, hope is clear enough

Thanks,

Camilo

Highlighted
MVP
MVP

Creating a value to show the % participation

So this is not what you want to see?

Mes112233
CuentaRealSales %RealSales %RealSales %
Costo113043,3%11027,5%9825,8%
Costo23010,0%6015,0%7720,3%
Ventas300100,0%400100,0%380100,0%
Highlighted
Contributor III
Contributor III

Re: Creating a value to show the % participation

Yes that is what I want to see!

Highlighted
MVP
MVP

Creating a value to show the % participation

Yes - this is not what you want or yes - it is?

This is my expression:

=sum(Real)/(Sum( total<Mes> {$<Cuenta={'Ventas'}>} Real))

Looks similar to what I suggested before, doesn't it

Highlighted
Contributor III
Contributor III

Re: Creating a value to show the % participation

Stefan,

How can I create that table???

Thanks,

Camilo

Highlighted
Contributor III
Contributor III

Re: Creating a value to show the % participation

Yes that is what I want !!

Sorry I didn´t see you had already answered, I try your solution but it doesn´t show any data...

Highlighted
MVP
MVP

Re: Creating a value to show the % participation

Here you are, I justed added the <Mes> after total in % expression.

Highlighted
Contributor III
Contributor III

Creating a value to show the % participation

It works perfectly!! I had an error on a variable.

Thanks Stefan!

Camilo