topic Re: Show two bars in equal size in QlikView

Show two bars in equal size

sarasunagaram — Fri, 08 Dec 2017 10:17:02 GMT

Hi All

Please help me to resolve this issue. Here we are using year as a dimension, it is showing two years of data in two bars. We need to show two bars in equal length.

Thanks in Advance

Muni

Re: Show two bars in equal size

Anil_Babu_Samineni — Fri, 08 Dec 2017 10:20:04 GMT

May be make it as Sum(TOTAL Measure) and don't enable data points.

Re: Show two bars in equal size

sarasunagaram — Fri, 08 Dec 2017 10:27:58 GMT

Hi Anil

We want see the data points .it is driving three exp in bar and one for no data and bars should be equal length.

Thanks,

Re: Show two bars in equal size

Anil_Babu_Samineni — Fri, 08 Dec 2017 10:38:18 GMT

May be attach to investigate where we are?

Re: Show two bars in equal size

sarasunagaram — Fri, 08 Dec 2017 10:46:32 GMT

Shall i provide sample data with app.

Re: Show two bars in equal size

Anonymous — Fri, 08 Dec 2017 13:18:19 GMT

Are you trying to show the percentage each dimension represents of the total count for each year? Like the image below:

Re: Show two bars in equal size

sarasunagaram — Fri, 08 Dec 2017 13:21:37 GMT

Hi Tabib

It looks same as my requirement.Can u guide me how to achieve this one.

Thanks,

Muni

Re: Show two bars in equal size

Anonymous — Fri, 08 Dec 2017 13:49:22 GMT

Try the following expression in your sample qvw:

=sum(Count) / sum(TOTAL <Id, Year> Count)