Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Not applicable

Values dimension in an unique value

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.

5 Replies
srchilukoori
Valued Contributor

Re: Values dimension in an unique value

Is this what you are trying to implement?

Not applicable

Re: Values dimension in an unique value

Srchilukoori,

no, i want this:

10001    Product1   1000

10001    Product2   1005

10001    Product3    990

10001    Product4    805

Re: Values dimension in an unique value

HI

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

srchilukoori
Valued Contributor

Re: Re: Values dimension in an unique value

try this.

Not applicable

Re: Values dimension in an unique value

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.


Community Browser