topic Re: Stack barchart in QlikView

Stack barchart

Anonymous — Tue, 14 Nov 2017 09:12:53 GMT

Hi Qlik Experts,

I have to create a stack bar chart , where all 4 stacks should cover 100% display but do not show value as % in data points.

They should show actual numbers for particular selection as shown in example below.

For eg- if for Jan, LMN has "Actual 1"=123 , "Actual 2"=22,"Actual 3"=11, then it should show as image 2.

I tried creating it by using normal stackbar chart & showing datapoint as number or % but its not solving the purpose.

Because when I try showing actuals as data points , the stack doesn't cover 100% display.

Image created in excel.

Appreciate the help,

Thanks in adv.

Re: Stack barchart

Anil_Babu_Samineni — Tue, 14 Nov 2017 09:34:14 GMT

Try to build same in Qlikview and explain where it is not working. I may understand your intend but more clear may help us

Re: Stack barchart

pradosh_thakur — Tue, 14 Nov 2017 10:09:20 GMT

like this

Re: Stack barchart

Anonymous — Tue, 14 Nov 2017 10:13:20 GMT

In qlikview 100% stackbar graph is correct but it gives me below data points-

But actually I want 100% range stackbar chart to show data points as original actual value as in we get in normal stack chart as below-

Re: Stack barchart

woshua5550 — Tue, 14 Nov 2017 10:31:43 GMT

Dual() function will help you out

check this

Re: Stack barchart

mdmukramali — Tue, 14 Nov 2017 10:52:29 GMT

Hi,

may be like this,

Find the attached Application (Updated File)

Thanks,

Mukram.

Re: Stack barchart

Anonymous — Tue, 14 Nov 2017 13:22:29 GMT

Thank You !

Re: Stack barchart

Anonymous — Wed, 15 Nov 2017 10:46:21 GMT

Hi Dave, the formula isn't working in my case , its giving me abrupt result on data points. (though creating 100% range stackchart)

Like A1,A2 mentioned in your doc are fields

in my case, field is date and stacks are generated using variables in expression.

I tried replacing A1,A2 with expressions , its giving me abrupt result on data points. (though creating 100% range stackchart)

Re: Stack barchart

mdmukramali — Wed, 15 Nov 2017 10:51:02 GMT

Hi,

Have you checked my Solution?

Re: Stack barchart

woshua5550 — Wed, 15 Nov 2017 10:55:15 GMT

can you provide a screenshot of your problem ? or provide a sample app

I'm not sure what does "abrupt result on data points" means , data label not looks good ? if yes ,you can use Num() function to format the data

Re: Stack barchart

Anonymous — Wed, 15 Nov 2017 11:50:12 GMT

Hello,

have created a sample doc with data and stack chart.

And gets output as below-

While converting this same to 100% stack bar chart and using the approach suggested by you gives me garbage values on data segments.

Can you please suggest here.

Re: Stack barchart

Sergey_Shuklin — Wed, 15 Nov 2017 12:03:11 GMT

Hello!

You may find this thread useful too:

which Qlikview chart Use??

Re: Stack barchart

Anonymous — Thu, 16 Nov 2017 06:08:29 GMT

I have posted sample app with data in this thread. Can you please take a look.

Re: Stack barchart

PrashantSangle — Thu, 16 Nov 2017 06:36:12 GMT

Hi,

Please find attachment might help you

Regards,

Prashant

Re: Stack barchart

woshua5550 — Fri, 17 Nov 2017 03:40:20 GMT

you can do it in two ways

1.one dimension and four expressions

2.two dimensions and one expressions

PFA

plz make sure that these two checkboxes are checked

Re: Stack barchart

Anonymous — Fri, 17 Nov 2017 10:35:22 GMT

This solution works totally ! Thank You.

Re: Stack barchart

Anonymous — Fri, 17 Nov 2017 10:35:43 GMT

This solution works totally ! Thank You.