Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
cannot open the link invalid set of parameters has been used in the url is the error coming up
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
Take a look at my previous post, I've updated the link. It should work.
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