topic Count in bar chart in qlikview in QlikView

Count in bar chart in qlikview

poonam_kulwal — Sat, 16 Nov 2024 03:37:30 GMT

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.

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.

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

sunny_talwar — Thu, 09 May 2019 17:19:17 GMT

Try this

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

poonam_kulwal — Thu, 09 May 2019 17:33:48 GMT

Thank you Sunny for quick help!
Appreciate your help.