topic Re: Pivot data problem in QlikView

Pivot data problem

Mon, 06 May 2013 20:29:38 GMT

Hi, I hope to be able ti clear up my issue. I have the following data

Dateregistration, Salesid, Articlecode, Salesamount

Since I have multiple salesamount on the same Dateragistration with a different salesid I have done as follows:

sum (aggr(sum (Salesamount),Salesid)) with Articlecode as dimension.

My problem is that both my pivot or plain table give me the right Salesmount value only when I select the single Articlecode field .But I would like to view the full list on my table , ordering it by Amount for example. If I do not select any Articlecode the values are wrong as if they are picked up as "distinct"

Thanks to whom has time to give me a tip

Re: Pivot data problem

sujeetsingh — Tue, 07 May 2013 05:12:12 GMT

post a sample plz

Re: Pivot data problem

Tue, 07 May 2013 06:34:30 GMT

OK thanks, I attach a pdf with the example

Re: Pivot data problem

jonathandienst — Tue, 07 May 2013 07:28:55 GMT

If you have ArticleCode as a dimension in your table, you will need to include it in the Aggr expression as well. Something like

Sum (aggr(sum (Salesamount),Salesid, Articlecode))

But I am not convinced that you need the aggr. The above expression should return the same results as

Sum(Salesamount)

Hope that helps

Jonathan

Re: Pivot data problem

Tue, 07 May 2013 19:41:32 GMT

Thanks Jonathan, it seems to work fine with the Article included in the expression.