Bar chart

[vireshkolagimat]

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

[#2]

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

Can you please post sample qvw ?

[MarcoWedel]

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

[t_chetirbok]

Hi!

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

[Anonymous]

What is your expression??

[manojkulkarni]

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')

[HirisH_V7]

Hi,

Can you post your sample app!

How your date field format is !!

-Hirish

[#8]

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.

[jagan]

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;

[vireshkolagimat]

Hi,

Its working fine. TY.