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: 
Biazo12
Contributor
Contributor

qlik sense help

Hi Everyone , i'm new to Qlik sense  I need help. i have a criteria and the users are asking me if  a stimulant doesn't meet a criteria they don't want to see it on the chart 

example is  say if i choose 3 factor and it give me 20 stimulant what i want to see is the stimulant that only meet that 3 factors

if it meets only 1 don't show me. right now i have as i see all the marching on my chart and the ones that doesn't meet 

Labels (1)
5 Replies
Vegar
MVP
MVP

Im not quite sure I understand  the details of your problem,  but it sounds like you could be helped by an AND mode selection. Check out this post: Generating AND, OR , NOT selection logic in Qlik Sense

Biazo12
Contributor
Contributor
Author

cannot open the link invalid set of parameters has been used in the url  is the error coming up 

Biazo12
Contributor
Contributor
Author

ex if my data is like this

K   factor( filters are isaac, david  amd mary

C   isaac , david , mary

U isaac david mary

L  mary

A  isaac 

B  david

now if i choose all 3 factor(filter) i dont want to see  L, A and B  cus it doesnt meet the criteria  please help

Vegar
MVP
MVP

Take a look at my previous post, I've updated the link. It should work.

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

Use a set like:

{<stimlulant={"=count(distinct factor) =count(distinct total factor)"}>}

You can use the set in a Measure, eg 
count({<stimlulant={"=count(distinct factor) =count(distinct total factor)"}>} factor)

Or a calculated dimension

aggr(only({<stimlulant={"=count(distinct factor) =count(distinct total factor)"}>}stimlulant), stimlulant)

(I may be missing some punctuation, none of this was syntax checked)

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com