Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
Im preety new to qlikview an I have a problem which i can't solve
SITUATION
PROBLEM
I want to sum 3 counts where prioname = blocker and sname is not Afgehandeld :
I HAVE TRIED:
Count({<prioname={'Blocker'}, sname = {'Verificatie'}>}iid)
Count({<prioname={'Blocker'}, sname = {'In Behandeling'}>}iid))
Above don't work
somebody any idea how to do this?
try this
Count({<prioname={'Blocker'}, sname =sname - {Afgehandeld}>}iid)
try this
Count({<prioname={'Blocker'}, sname =sname - {Afgehandeld}>}iid)
Hi,
Try with this expression
Count({<prioname={'Blocker'}, sname-={'Afgehandeld'}>} iid)
Celambarasan
no succes
I'm getting 0 as result.
can you post sample data
it should work
Hi
What you have used is appropriate only thing is you should use "Double Quotes" instead of single one as mentioned below.
Count({<prioname={"Blocker"}, sname <> {"Afgehandeld"}>}iid)
If it still doesn't work, please share sample data / attachment.
no doesn't work
Hope this makes some clear?
Is this enough info? of do you need more?
Can you attach the sample QVW file?
Well, i don't know what happned, But after resarting Qlikview .. the solutions which where sugested, worked!
Thnx all for the help