Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Specialist
Specialist

Is this what you are trying to implement?

Not applicable
Author

Srchilukoori,

no, i want this:

10001    Product1   1000

10001    Product2   1005

10001    Product3    990

10001    Product4    805

MayilVahanan

HI

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

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
srchilukoori
Specialist
Specialist

try this.

Not applicable
Author

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.