Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
madushanfernand
Contributor III
Contributor III

Stack Bar chart with multiple dimension

Hi

please see the bar chart created on excel with X axis dimensions Buyer and FactoryName (Chart 2).

and i have created a stacked bar chart in qlikview from the same data set ( Chart 1). But i want to separate the buyer list for each Factory Name by a vertical line on X axis  as shown in Chart 2  since my qlikveiw chart ( Chart 1) shows all the buyers together and cant identify which factory they are from.

Additionally i want to remove buyer names which has no values on the chart as chart 2 shows.

please help me to sort this out.

thanking in advance.

Chart 1.

Capture12.JPG

Chart 2.

Capture11.JPG

5 Replies
ritesh_kodolikar

Hi,

select Grouped chart instead of Stacked for dimensions.

As per your second chart you have used two expression one for the Jul Late and Jul ontime

so you have two use two expression and two dimensions.

Thanks

madushanfernand
Contributor III
Contributor III
Author

Hi Ritesh

I have used two dimensions and two expressions for my qlikview chart as well.

Dimensions

1. Buyer

2. Factory

Expressions

1. Jul Late

2. Jul Ontime

and already chart is on grouped mode.

what i want is to remove blank bars from the chart ( for an example referring to your image, if your June month has no sales then its bar should be disappered ).

and to use a separator line ( Vertical ) as shown in my excel chart.

manoj217
Creator III
Creator III

You want to show the data if it have some value right?

manoj217
Creator III
Creator III

write if condition

if ( sum( dimension)>0,Sum(dimension))

madushanfernand
Contributor III
Contributor III
Author

Hi Manoj

thank you for the reply.but if condition didn't work. but i found following post regarding the same issue which i had.

It gave me a close enough solution.

conditional to hide bars in bar chart?