topic Display only some information in a Line Chart but add information with filters when I want in App Development

Display only some information in a Line Chart but add information with filters when I want

Manuel174102 — Tue, 09 Aug 2022 13:03:54 GMT

Hello everyone

So I have a line chart which is displaying information of 7 categories.

I only want to display at all times the information of two of them, but I want to be able to add the other categories when I want, through a filter. How could I do that?

The field name is Order Type, and the categories I want to show are Service and Delivery.

thanks

Re: Display only some information in a Line Chart but add information with filters when I want

luizcdepaula — Tue, 09 Aug 2022 14:09:11 GMT

Hi Manuel,

One way of accomplishing that is using the expression below. I personally don't like IF statements, as they can affect performance, however, I couldn't find another yet. Let me know if that works for you.

If(GetSelectedCount([Order Type])>0,
Count(distinct {$<[Order Type]+={'Service','Delivery'}>} [Measure]),
Count(distinct {$<[Order Type]={'Service','Delivery'}>} [Measure]))

The solution I found was adding the modifier '+' to add the the 2 values as the default selected values.

Cheers,

Luiz

Re: Display only some information in a Line Chart but add information with filters when I want

Manuel174102 — Wed, 10 Aug 2022 07:32:46 GMT

Hello Luiz,

Thanks for answering.

It is not working out.

I get the following message : Error in expression: Nested aggregation not allowed.

Greetings,

Manuel

Re: Display only some information in a Line Chart but add information with filters when I want

luizcdepaula — Wed, 10 Aug 2022 13:40:45 GMT

Hi Manuel,

That is very strange, as I tested on my side and I don't get the error, and it worked for me.

Are you applying the logic in the visualization? If so, are you using QlikView or Qlik Sense? Not sure if that really matters as I believe QlikView would still work.

Luiz

Re: Display only some information in a Line Chart but add information with filters when I want

Manuel174102 — Wed, 10 Aug 2022 13:43:37 GMT

I finally just set a default bookmark.

I thank you for helpimg me out. Prob it is not working cuz I am new and still learning!

Re: Display only some information in a Line Chart but add information with filters when I want

luizcdepaula — Wed, 10 Aug 2022 13:47:13 GMT

I am glad you found a solution.

Keep in mind that as a bookmark, people can still deselect the default 2 values. With that logic, anytime you make a selection, the default values will always be selected.

Cheers,

Luiz