Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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.

Labels (1)
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)