Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
vireshkolagimat
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
Not applicable

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
Specialist
Specialist

Hi!

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

balrajahlawat
Champion
Champion

What is your expression??

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

HirisH_V7
Master
Master

Hi,

Can you post your sample app!

How your date field format is !!

-Hirish

HirisH
“Aspire to Inspire before we Expire!”
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.

jagan
MVP
MVP

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
Creator III
Creator III
Author

Hi,

Its working fine. TY.