topic Re: Problem show in pivot table. in QlikView

Problem show in pivot table.

fdelacal — Fri, 02 Aug 2013 11:48:55 GMT

HI all. i have a problem in pivot table.

See image i atach,

thanks in adavance.

Re: Problem show in pivot table.

fdelacal — Mon, 05 Aug 2013 06:32:40 GMT

anyone can tell me somthing?

Re: Problem show in pivot table.

ariel_klien — Mon, 05 Aug 2013 06:36:09 GMT

Hi,

Can you send an example file or what is the expression?

Ariel

Re: Problem show in pivot table.

fdelacal — Mon, 05 Aug 2013 06:43:45 GMT

The expression is:

num(BILLLINES.VATTAX/100,FormatoNumPorcen)

Varible FormatoNumPorcen= #.##0%

Regards.

Re: Problem show in pivot table.

ariel_klien — Mon, 05 Aug 2013 07:03:22 GMT

Hi,

Try

num(Sum(BILLLINES.VATTAX)/100,FormatoNumPorcen)

Ariel

Re: Problem show in pivot table.

fdelacal — Mon, 05 Aug 2013 07:10:00 GMT

Not work, see image.

thanks.

Re: Problem show in pivot table.

ariel_klien — Mon, 05 Aug 2013 07:16:06 GMT

hi,

Try

num(Avg(BILLLINES.VATTAX)/100,FormatoNumPorcen)

Re: Problem show in pivot table.

fdelacal — Mon, 05 Aug 2013 07:25:47 GMT

Ariel Klien thanks again but still not working.

er.mohit look better solution but not work too.. i atach an image that you can see the result.

Regards.

Re: Problem show in pivot table.

Mon, 05 Aug 2013 07:27:40 GMT

TRY THIS

num((BILLLINES.VATTAX/sum(total BILLLINES.VATTAX)),'##00%')

WHERE VARIABLE NAME IS

FormatoNumPorcen='##00%'

******************************************

OR TRY THIS

num((

sum(DISTINCT BILLLINES.VATTAX)/sum(total BILLLINES.VATTAX)),'##00%')

WHERE VARIABLE NAME IS

FormatoNumPorcen='##00%'

Re: Problem show in pivot table.

fdelacal — Mon, 05 Aug 2013 07:39:34 GMT

Still not working, thanks for all answerd!!

Atach an image!!

Regards

Re: Problem show in pivot table.

fdelacal — Tue, 06 Aug 2013 10:23:39 GMT

Some one with an Idea.??

Re: Problem show in pivot table.

sathishkumar_go — Tue, 06 Aug 2013 10:45:32 GMT

HI, It could be many reason. you have to use aggr function. Please select the "TICKET" 67129 and "Familia" Color Science after that please check the 1st table I.V.A shows value or not? Regards Sathish

Re: Problem show in pivot table.

fdelacal — Tue, 06 Aug 2013 11:18:12 GMT

Is the same value. here it´s look like, i tried to do with aggr, but not working for me.

any suggest??

i atach a image

Re: Problem show in pivot table.

sathishkumar_go — Wed, 07 Aug 2013 05:56:17 GMT

HI, Is it possible to attach the QVW? Regards Sathish

Re: Problem show in pivot table.

mikecrengland — Wed, 07 Aug 2013 15:44:10 GMT

I think everyone is on to the same idea and it relates to Henric's post (http://community.qlik.com/blogs/qlikviewdesignblog/2013/08/06/it-s-all-aggregations).

When you close the group of the pivot table, QlikView can't resolve the expression because it just doesn't know what to look for. The first image shows that there are different VATTAX for each Familia, so you can't simply say give me num(vattax,'##.#%') because it doesn't know which to return when the sections are collapsed.