Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Talk to Experts Tuesday, Live Q&A, September 22: Moving from QlikView to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator III

Bar chart

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

10 Replies
Highlighted
Not applicable

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

Can you please post sample qvw ?

Highlighted

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

Highlighted
Specialist
Specialist

Hi!

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

Highlighted
Champion
Champion

What is your expression??

Highlighted
Partner
Partner

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

Highlighted
Master
Master

Hi,

Can you post your sample app!

How your date field format is !!

-Hirish

HirisH
“Aspire to Inspire before we Expire!”
Highlighted
Not applicable

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.

Highlighted
MVP & Luminary
MVP & Luminary

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;

Highlighted
Creator III
Creator III

Hi,

Its working fine. TY.