topic Re: Bar chart in QlikView

Bar chart

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

Hi,

I want to create a leakage report using bar chart.

I want one bar showing actual allocated hours,

2nd bar showing hours worked and 3rd bar showing leakage(=actual -allocated)

I want it daily as well as week wise.

if I use sum(hours worked) expression for daily it is totalling the hours for the particular resource .

Please help me with this

Re: Bar chart

sunny_talwar — Fri, 17 Nov 2017 12:45:59 GMT

Would you be able to share a sample to check this out?

Re: Bar chart

Anonymous — Fri, 17 Nov 2017 14:40:35 GMT

I have data in both these files

Re: Bar chart

Anonymous — Fri, 17 Nov 2017 16:58:15 GMT

The outline alone is correct

I don't know what expression to use.

and for weekly data I have to roll up the dates keeping Friday as week end date.

please help with this

Re: Bar chart

settu_periasamy — Fri, 17 Nov 2017 17:23:52 GMT

Hi,

Seems to the Table is not linked Properly

I think, if you correct that, the data will show proper.

Re: Bar chart

Anonymous — Sat, 18 Nov 2017 03:58:41 GMT

how to connect the tables?

Re: Bar chart

vishsaggi — Sat, 18 Nov 2017 04:07:16 GMT

You have to find a common field between two tables then rename one of the fields to the that field which you want to make a key. For eg. if you think POD and PODs should match. Then just rename the Field PODs to Like PODs AS POD.

Re: Bar chart

Anonymous — Sat, 18 Nov 2017 04:12:22 GMT

I thought it will become synthetic key

so I reamed POD as PODs in one of the file

and the connection works fine

the problem is with the expression.

Re: Bar chart

Anonymous — Sat, 18 Nov 2017 04:39:48 GMT

After joining the tables the values displayed at the points are corrected.

but consider the worked hr for soumya is 0 for all the days, it is showing some other value.

Only for first date it is showing correctly