Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

expression in a table

Hi,

Please i want to ask how to evaluate expression in a table dependent on a dimension (not the dimension of the table)

i mean if i have 2 dimensions x,y

and i have 2 expressions exp1,exp2

exp1 dependent on x

exp2 dependent on y

i want to make a straight table contain these two expressions and one dimension of them

how to make this

note, the values in x and y are the same but they can't be a relation between them.

Thanks in advance,

Mona.

1 Reply
whiteline
Master II
Master II

Hi.

You can use total to discard dimensions in your expressions:

=sum(total<x> value)
=sum(total<y> value)