Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Action-Packed Learning Awaits! QlikWorld 2023. April 17 - 20 in Las Vegas: REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set analysis not working like it should

Hi,

Can someone explain my why adding the TYPE in the pivot table makes the formula below not work anymore.

Sum({$<TYPE={"Dmtthjs"}>} [Sal Serv Other])

Can anyone help me to get it to work again?

The idea is that I can reuse the value of TYPE='Dmtthjs' for the other values of TYPE.

Yqtqanj
Dmtthjs
Sxrddvf

Kind Regards,

Dion

1 Solution

Accepted Solutions
lironbaram
Partner - Master III
Partner - Master III

hi

in this case you cant use set analysis because it select one type so in the other types it gives you null

check the attach file

i changed the expression to if clause

View solution in original post

1 Reply
lironbaram
Partner - Master III
Partner - Master III

hi

in this case you cant use set analysis because it select one type so in the other types it gives you null

check the attach file

i changed the expression to if clause