topic Re: Bar Chart Help in QlikView

Bar Chart Help

Fri, 31 Jul 2015 09:56:01 GMT

My dimension for the bar chart is date field, there are almost 150 values(5 months) in it but I want to show only one month data(latest month).

Thanks.

Re: Bar Chart Help

sunilkumarqv — Fri, 31 Jul 2015 10:01:23 GMT

Expression: sum({<DateField={">=$(=Num(MonthStart(Max(Datefield))))"},Year=,Month=,DateField>}value)

Re: Bar Chart Help

Kushal_Chawda — Fri, 31 Jul 2015 10:01:27 GMT

use calculated dimension

=date(max(monthname(Date)),'MMM-YYYY')

Re: Bar Chart Help

sorrakis01 — Fri, 31 Jul 2015 10:02:34 GMT

Hi,

Create a calculated dimension or use set analysis.

Calculated Dimension date(max(monthname(Date)),'MM-YYYY')

Regards,

Re: Bar Chart Help

Fri, 31 Jul 2015 10:13:48 GMT

Thank you all for your quick response,

My bad I didn't put question in right way,

I am expecting latest month i.e., 30 bars in bar chart.

Re: Bar Chart Help

Kushal_Chawda — Fri, 31 Jul 2015 10:21:53 GMT

Try this

=sum({<DateField={">=$(=date(monthstart(max(monthname(Datefield))),'YourDateFieldFormat'))<=$(=date(monthend(max(monthname(Datefield))),'YourDateFieldFormat'))"},Year,Month,DateField>}value)

Re: Bar Chart Help

Kushal_Chawda — Sat, 01 Aug 2015 17:27:06 GMT

have you resolved ?

Re: Bar Chart Help

maxgro — Sat, 01 Aug 2015 17:34:49 GMT

last 30 days?

sum({$<year=,month=,date={">=$(=date(today()-30))<=$(=date(today()))"}>} value)

Re: Bar Chart Help

sunny_talwar — Sun, 02 Aug 2015 05:16:48 GMT

Like this?

Since 6/14/2015 is the max date in the database, you will see the bar chart starting from 5/15/2015 and goes up till 6/15 2015 (30 days)

Expression:

=Sum({<Date = {"$(= '>=' & Date(Max(Date)-30) & '<=' & Date(Max(Date)))"}>}Value)

I used just date here without specifying its format because I used Date() function in the script also which takes the same format that I specified at the beginning of my script:

SET DateFormat='M/D/YYYY';

Table:

LOAD Date(41639 + IterNo()) as Date,

Ceil(Rand() * 100000) as Value

AutoGenerate 1

While IterNo() <= 530;

You may not be using Date function for you date. and if that's true than you would need to use the same format as you date in the set analysis function:

=Sum({<Date = {"$(= '>=' & Date(Max(Date)-30, 'yourDateFormat') & '<=' & Date(Max(Date), 'yourDateFormat'))"}>}Value)

I hope this would help you.

Best,

Sunny

Re: Bar Chart Help

qlikviewwizard — Sun, 02 Aug 2015 05:24:52 GMT

Please use calculated dimension like this. Hope this will help you.

=date(max(monthname(Date)),'MM-YYYY')