Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

conditional for expression

Hi everyone!

I'm making a sport app and i got a problem with bar chart in which i want to show how many points player made in the given time interval. I want to make conditionals for intervals where player didn't make any points that they are not shown. It sounds like very easy but i can't solve this problem.

Please help if you got any ideas.

peace!

1 Solution

Accepted Solutions
Not applicable
Author

ok i did it. sometimes the easiest solution become the hardest;)

in conditional i put this sentence: Sum({<IntervalName={"80'"}>} PTS)>0

and it works exactly like i wanted. Sorry for confusion and thanks for answers

regards

View solution in original post

8 Replies
joshabbott
Creator III
Creator III

So your dimension is date, and your expression is points?

lft
Employee
Employee

Hi Bartosz,

have you tried checking the "suppress 0 values" in the presentation tab in combination with "suppress null values" in the dimension tab ?

Loic

Not applicable
Author

It would be easy to debug if you could attach a sample app.

Not applicable
Author

my dimension is player name and expression are points from given interval name and from whole career so it looks like first expression is sum(PTS) and next is Sum({<IntervalName={"80'"}>} PTS) and the same for 90' 2K0 and 2K10

Not applicable
Author

i tried many combinations connected with these options but it doesn't work

Not applicable
Author

ok i did it. sometimes the easiest solution become the hardest;)

in conditional i put this sentence: Sum({<IntervalName={"80'"}>} PTS)>0

and it works exactly like i wanted. Sorry for confusion and thanks for answers

regards

lft
Employee
Employee

Hi,

can you mark this question as answered ?

Thanks a lot,

Loic

Not applicable
Author

there you go;)