topic Re: Values dimension in an unique value in QlikView

Values dimension in an unique value

Mon, 26 Jan 2026 18:19:17 GMT

Hello,

i have a table with two dimensions and one expression.

Dimension 1: '10001', 10002', '10003', '10004'

Dimension2: Product1, Product2, Product3, Product4, Product5

Expression: Sum(Total<Dimension2> Value)

I want show in the table just value '10001' in the first dimension, in second dimensión all products.

Not all values Dimension 2 have data in all values of Dimension 1

Please help me.

Re: Values dimension in an unique value

srchilukoori — Thu, 26 Sep 2013 16:47:26 GMT

Is this what you are trying to implement?

Re: Values dimension in an unique value

Thu, 26 Sep 2013 17:07:34 GMT

Srchilukoori,

no, i want this:

10001 Product1 1000

10001 Product2 1005

10001 Product3 990

10001 Product4 805

Re: Values dimension in an unique value

MayilVahanan — Thu, 26 Sep 2013 17:11:09 GMT

Its not possible. Without any mapping , you can't use like tat

Re: Re: Values dimension in an unique value

srchilukoori — Thu, 26 Sep 2013 17:14:04 GMT

try this.

Re: Values dimension in an unique value

Thu, 26 Sep 2013 17:24:56 GMT

Thanks,

i wanted to know if this was possible just with any function, because the code, in this case, is used to other reports too where its necesary show all values of Dimensión 1.

Anyway, thanks, i can see this is not possible.