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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
javi_martinez
Contributor
Contributor

Ignore user selection but set a value on the same field using set analysis

Hi all, 

I want to do a measure for sum a value but I want to ignore user selection on a filter and set this filter to an specific value.

I show you what I want to:

sum({< field_a= {"7"}
, field_b -- ignore user selection
, field_b = {"ABCD"} -- set to a specific value
>} measure_a)

In this case, I want to ignore the user selection on "field_b" and set it with a specific value, "ABCD" .

I don't how to do it ...

Can you please help me with that? 

Thanks!

Labels (1)
3 Replies
rpennacchi
Contributor III
Contributor III

Hi, Javi,

When you specify a filter for a field in set analysis, you are already disregarding user's selection for that field. So you only need to do this:

sum({< field_a= {"7"}
, field_b = {"ABCD"}
>} measure_a)

 

Find me on linkedin:
https://www.linkedin.com/in/rodrigo-pennacchi/
javi_martinez
Contributor
Contributor
Author

Hmm it doesn't work, but I don't know why...

I mean, for example if I filter FIELD_B to "1234" and I use that set analysis the measure shows empty.  

rpennacchi
Contributor III
Contributor III

Can you send a screenshot of your data model?

Find me on linkedin:
https://www.linkedin.com/in/rodrigo-pennacchi/