Qlik Community

Qlik Sense App Development

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

Not applicable

Combo Chart - formula needed to filter out info

hello forum,

I would need your help with below challenge.

i would need to create a combo chart to show simultaneous 2 categories using Bar chart type.

I know i need to pt some formula to restrict the count for the values for "catA" and respectivelly "catB" but i don't know how.

any help/direction is more than welcome

Untitled.png

1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Re: Combo Chart - formula needed to filter out info

Using [Dunning Level] as dimension as you do now and add two expressions for the two categories:

  • count({<MyCategory={'catA'}>} MyItem)
  • count({<MyCategory={'catB'}>} MyItem)

Replace MyCategory and MyItem with the appropriate field names from your data model.


talk is cheap, supply exceeds demand
3 Replies
MVP & Luminary
MVP & Luminary

Re: Combo Chart - formula needed to filter out info

Using [Dunning Level] as dimension as you do now and add two expressions for the two categories:

  • count({<MyCategory={'catA'}>} MyItem)
  • count({<MyCategory={'catB'}>} MyItem)

Replace MyCategory and MyItem with the appropriate field names from your data model.


talk is cheap, supply exceeds demand
Not applicable

Re: Combo Chart - formula needed to filter out info

worked like a charm.

thanks a million. can u please suggest some reference materials where I can learn how to build these formulas?

MVP & Luminary
MVP & Luminary

Re: Combo Chart - formula needed to filter out info

You can find some information here: A Primer on Set Analysis


talk is cheap, supply exceeds demand