Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Not applicable

Filter data in chart

Hi all,

I would appreciate any help.

I have a set of data, consisting of  (subset) of data:

TicketIDStateAge
123closed01-02 Days
136openN/A
156closed03-05 Days
163closed06-10 Days
.........

I want to exclude the non-closed tickets, represented as (N/A) in my graphic, as I want to represent the time taken to close each ticket, aggregated in "time-slots".


d0cdf5148ca5415a955e8aa5e290225b.png

Can someone please help?

Thanks

Regards

1 Solution

Accepted Solutions
MVP
MVP

Re: Filter data in chart

What is the expression you are using? Assuming it is Sum(FieldName), change it to this may be -> Sum({<Age -= {'N/A'}>}FieldName)

2 Replies
MVP
MVP

Re: Filter data in chart

What is the expression you are using? Assuming it is Sum(FieldName), change it to this may be -> Sum({<Age -= {'N/A'}>}FieldName)

Not applicable

Re: Filter data in chart

Thanks,

That resolved my issue!

Regards,