Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
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/