Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
Partner
Partner

Count in bar chart in qlikview

Hi All,

I am facing challenge to plot bar chart.

I have a sample store data with two tables Product_InStock and Product_Sold.

What I need to find out, How many times Product reached Out of Stock in a month/Year .

I want to plot a bar char with Products on X axis and respective Count on Y axis.

As shown in the image.

pic.png

I am able to get dates for which Product is out of stock in Pivot table form but not able to get count in bar chart.

pic2.png

I want to keep both table separate as this is just a very small part of big script. This is how two tables are connected to calendar.

I have attached my sample file with data.

Appreciate your help on this.

Thanks & Regards,

Poonam

1 Solution

Accepted Solutions

Re: Count in bar chart in qlikview

Try this

=Count(DISTINCT Aggr(If(Max({<InStock_Category = {'Type B'}>}[Quty InStock]) = Max({<Category = {'Type B'}>} [Quty sold]), Date), Product, Date))
2 Replies

Re: Count in bar chart in qlikview

Try this

=Count(DISTINCT Aggr(If(Max({<InStock_Category = {'Type B'}>}[Quty InStock]) = Max({<Category = {'Type B'}>} [Quty sold]), Date), Product, Date))
Partner
Partner

Re: Count in bar chart in qlikview

Thank you Sunny for quick help!
Appreciate your help.