Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Pivot table with distinct values and values per dimension

Hi. I'm having trouble with making a table. I've run into this several times, and wonder if any of you have a sollution.
The table you see here is what I'm trying to do.
Note that it is a pivot table, where the customer can use the [+] to drill down to Country, some cyclic group selections, projects etc.
COUNTRY<CYCLICGROUP>PROJECTSCUSTOMERorderamount

YYMM
201301

YYMM2
201302

YYMM
201303
SUM(Orderamount)

SUM(Margin

per month)

SUM(Margin

per month)

SUM(Margin

per month)

This should be a distinct value

Ofcourse I have no problems with putting the dimensions there and getting the formule SUM(Margin per month) to work.
The problem for me is the SUM(Orderamount). Which should only be shown once. (There are actually 8 such formula which should be distinct, and not per month).
How do I do this? What is the correct formula to get the sum(Orderamount) to only show once. Keeping in mind that there is a cyclic group and such.
(Also, if I have to let that part go, that's ok. But then I still can't get it to work).
Thanks!
4 Replies
er_mohit
Honored Contributor II

Re: Pivot table with distinct values and values per dimension

use aggr function on the basis of that you got orderamount

like

aggr(sum(distinct Orderamount),basedfieldname)

sushil353
Honored Contributor II

Re: Pivot table with distinct values and values per dimension

Please post the sample application

Not applicable

Re: Pivot table with distinct values and values per dimension

Hereby you receive the sample application as per your request.

Not applicable

Re: Pivot table with distinct values and values per dimension

But how will that work with Cyclic groups?

Also, I have to name all the dimensions right?

I've also upload an example file in another post just down...

Community Browser