topic Re: Bar chart in QlikView

Bar chart

vireshkolagimat — Wed, 20 Jan 2016 14:38:02 GMT

Hi team,

I am trying to create a bar chart as shown below but for each date i am getting the count of calls separately.

Kindly let me know what is wrong.

regards,

Viresh

Re: Bar chart

Wed, 20 Jan 2016 17:10:09 GMT

Create Bar chart with only Date as Dimension and Count(CallID) as Expression.

Can you please post sample qvw ?

Re: Bar chart

MarcoWedel — Wed, 20 Jan 2016 23:24:12 GMT

your call dates are in fact timestamps (non integer / having a fractional time part) and are just formatted as dates.

Try to load the dates without time information e.g. like:

LOAD DayName(Date) as Date,
          ...
FROM YourSource;

or use

DayName(Date)

instead of Date as calculated dimension.

hope this helps

regards

Marco

Re: Bar chart

t_chetirbok — Thu, 21 Jan 2016 06:27:35 GMT

Hi!

modify your filed Date to date(floor(Date)) as Date

Re: Bar chart

Anonymous — Thu, 21 Jan 2016 06:32:00 GMT

What is your expression??

Re: Bar chart

manojkulkarni — Thu, 21 Jan 2016 06:35:24 GMT

Your data contains timestamp, so you are getting multiple bars for same day.

Use floor function to truncate the timestamp & get date portion out of it.

date(floor(DateField),'DD-MM-YYYY')

Re: Bar chart

HirisH_V7 — Thu, 21 Jan 2016 06:50:18 GMT

Hi,

Can you post your sample app!

How your date field format is !!

-Hirish

Re: Bar chart

Thu, 21 Jan 2016 06:51:25 GMT

Hi Viresh,

First,choose your 'Date' as dimension,and in expression use 'sum(calls)' ,count() will give you the frequency and sum() will give you the sum of that field and yes after all the result will get a Group By according to your dimension. So,easy solution for your query make date as your dimension and make sum() or count() according to your requirement in expression.

Qlik On.

Re: Bar chart

jagan — Thu, 21 Jan 2016 07:04:55 GMT

Hi,

I think there is a timestamp in your date filed, round it off like below then you won't get this issue

LOAD

Date(Floor(DateFieldName)) as DateFieldName.

From DataSource;

Re: Bar chart

vireshkolagimat — Thu, 21 Jan 2016 08:46:10 GMT

Hi,

Its working fine. TY.

Re: Bar chart

jagan — Fri, 22 Jan 2016 01:08:06 GMT

Hi,

If you got the answer close this thread by giving correct/helpful answers to the posts which helps you.

Regards,

jagan.