topic Re: Charts for counts based on dates in QlikView

Charts for counts based on dates

Tue, 04 Mar 2014 13:32:53 GMT

Hello guys,

I am pretty new to Qlikview.I need to design a chart in qlikview.In my current report I am showing table box which shows all the table content.Now I have to show a chart with it.

In my scenario ,my table has 2 two columns, one has date and other has some repeated values.Now I have to calculate the counts of repeated values based on month appears in date column.

for eg:

Date Values

01/01/2014 a

24/01/2014 b

01/01/2013 a

24/12/2013 b

01/01/2014 a

24/02/2014 b

now counts are::

a counts --

for jan13-1

for jan14-2

b counts--

for dec 13-1

for jan14-1

for feb14-1

What chart can I use for this scenario and please suggest me expression for it.

Thanks in advance.

Re: Charts for counts based on dates

Tue, 04 Mar 2014 13:36:23 GMT

Hi,

use for dimension the month as a calculated dimension or add a new field month in your table in the script

expression is count(values) according to the dimension you choose.

any graph like bar, straight, pivot, lines can fit your needs

best regards

christian

Re: Charts for counts based on dates

Tue, 04 Mar 2014 13:49:40 GMT

Hi Tushar,

see attached example.

I used two types of charts for better understanding: Straight Tables and Pivot Tables.

All kind of charts (table, bar, radar, ...) have two main topics:

-- dimensions (like Year, Month, ...., Customer, region...)

-- expressions (like sum(Amount), Count(Parts), ....

These can be modified via chart properties --> dimension tab and/or expression tab.

HtH

Roland

Note:

Changed date fromat into german.

Re: Charts for counts based on dates

Tue, 04 Mar 2014 13:52:38 GMT

thanks for reply.I have use the expression you suggested but we have to find out the counts for a and b differently.The expression you suggested didnt counts for a and b differently,it just show total counts.

I am using month(date) in calculated dimension and count(values) in dimension.

Re: Charts for counts based on dates

Tue, 04 Mar 2014 14:23:30 GMT

thanks Roland,this is perfect

Re: Charts for counts based on dates

veidlburkhard — Tue, 04 Mar 2014 14:27:48 GMT

Hi Tushar,

I took your sample data and created a pivot table counting the a's and b's per date.

See the picture below. Hope this is what you wanted to achieve.