topic Re: Urgent - Need help in creating Grouped Bar Chart in QlikView

Urgent - Need help in creating Grouped Bar Chart

sayadutt — Wed, 25 Nov 2020 16:16:04 GMT

Hi Team,

I have a requirement where I need to show some bar graphs grouped by some conditions.

The data i have is:

And below is the graph i am looking for. (sample only, no link with data and graph)

Thanks in advance!!!

kkkumar82 — Mon, 21 Mar 2016 10:21:23 GMT

Take first dimension as Division , second dimension as Apllicable for tracking and measure as Count(Project Name)

Thanks

Kiran Kumar

sayadutt — Mon, 21 Mar 2016 10:26:05 GMT

Hello,

How to get the x-axis dimension then? Based on GoLive Month? Feb-16, March-16 etc

Gysbert_Wassenaar — Mon, 21 Mar 2016 10:27:24 GMT

See attached example.

kkkumar82 — Mon, 21 Mar 2016 10:29:50 GMT

Hi,

Please find attached?

Kiran Kumar

avinashelite — Mon, 21 Mar 2016 10:31:03 GMT

1.add Monthname(GoLiveDate) as dimension 1

2.add Division as dimension 2

add two expression like below

count({<[ApplicableforTracking]={Yes}>}Divison)

count({<[ApplicableforTracking]={No}>}Divison)

and go to presentation tab and check the stacked bar chart option

ramasaisaksoft — Mon, 21 Mar 2016 10:35:01 GMT

Hi Satyantan,

I hope u need to take 3 Dimensions Month,Division and Tracking

exp like :Count(project Name)

pooja_sn — Mon, 21 Mar 2016 10:35:33 GMT

Find attachment.

santhosh_k_n — Mon, 21 Mar 2016 10:43:24 GMT

Hi Sayanta,

Try applying Trellis available in the Dimension tab.

make sure u have placed dimension in correct order.

BR,