topic Re: calculated dimension in QlikView

calculated dimension

Wed, 25 Nov 2020 16:16:04 GMT

Hi Experts,

i have a pivot table like below

wherever a particular product number has two or more customer details in it, then i want to display as Customer 1, Customer 2, Customer 3, & so on...

Required output:

is it possible?

if so, can someone please help me with the calculations?

Re: calculated dimension

sunny_talwar — Fri, 21 Oct 2016 14:01:44 GMT

May be like this in your calculated dimension for [Customer Details]

Aggr(If(Count(TOTAL <Area, [Product No]>[Customer Details]) > 1, 'Customer ' & RowNo(), [Customer Details]), Area, [Product No], [Customer Details])

Re: calculated dimension

marcus_sommer — Fri, 21 Oct 2016 14:10:48 GMT

If you are handling with a large dataset it might be better to create this as new field within the script than such calculated dimensions could be slow down the app-performance.

- Marcus

Re: calculated dimension

Fri, 21 Oct 2016 14:13:45 GMT

thank u so much