topic Re: Bar will come after Quarter completed in QlikView

Bar will come after Quarter completed

prma7799 — Tue, 22 Dec 2015 05:24:08 GMT

Dear All,

I have one chart with one dimension in that all data is showing perfectly but my requirement in below chart I want to display Q3 bar after it completed means after 31-Dec-15 .

I don't want to display bar for Q3.

PFA..

Thanks

Re: Bar will come after Quarter completed

tresB — Tue, 22 Dec 2015 06:05:15 GMT

Not very clear!

Could you post a sample screenshot how the output should look like?

Re: Bar will come after Quarter completed

prma7799 — Tue, 22 Dec 2015 06:14:06 GMT

Hi Tresesco,

I don't want bar for Q3 for time being because Q3 is not completed yet. It should display but after 31th December month sales happens.

So I want completed Quarter ...

Q4 Should display on 1st April 2016

PFA I don't want highlighted bar

Re: Bar will come after Quarter completed

sundarakumar — Tue, 22 Dec 2015 06:15:36 GMT

you can try something like

1. Create a master calendar

2. add a quarter_end_flag in the master calendar, with the help of it do a resident load of qurater that have a quarter_end_flag

3. use this field in as chart dimension.

-Sundar

Re: Bar will come after Quarter completed

Tue, 22 Dec 2015 06:18:08 GMT

Hi PFA,

Try to use a flag to control the display of your dimension and expression. Please see attached the flag that I have added to your graph properties tabs:

Dimension
Expressions
Sort

Kind Regards,

Arohan

Re: Bar will come after Quarter completed

tresB — Tue, 22 Dec 2015 06:23:09 GMT

There could be many solutions. One is using calculated dimension like:

Aggr(If(Count(Distinct Date)=3,QuarterYear),QuarterYear)

PFA

Re: Bar will come after Quarter completed

Kushal_Chawda — Tue, 22 Dec 2015 06:31:45 GMT

Put below calculated dimension & check Suppress when value is null

=aggr(if( monthname(max(Date))=monthname(QuarterEnd(max(Date))),QuarterYear),QuarterYear)

Re: Bar will come after Quarter completed

prma7799 — Tue, 22 Dec 2015 06:58:17 GMT

Hi All,

Can anyone tell me same for Months I want bar for completed months.

Dim: MonthYear

PFA I don't want highlighted bar

Re: Bar will come after Quarter completed

Tue, 22 Dec 2015 07:03:16 GMT

I'd use this as a formula for the dimension and expression

if(MonthEnd<Today(),MonthYear)

Re: Bar will come after Quarter completed

Kushal_Chawda — Tue, 22 Dec 2015 07:05:33 GMT

try this

=aggr(if( monthname(max(Date))=monthname(MonthEnd(max(Date))),MonthYear),MonthYear)

Re: Bar will come after Quarter completed

prma7799 — Tue, 22 Dec 2015 07:10:39 GMT

Hi Kush,

I tried this but not achieve the same .

Thanks

Re: Bar will come after Quarter completed

tresB — Tue, 22 Dec 2015 07:11:10 GMT

=aggr(if( Day(max(Date))=Day(MonthEnd(max(Date))),MonthDimension), MonthDimension)

Re: Bar will come after Quarter completed

prma7799 — Tue, 22 Dec 2015 07:18:54 GMT

Thanks to All...

Re: Bar will come after Quarter completed

Kushal_Chawda — Tue, 22 Dec 2015 07:29:04 GMT

try

aggr(if( max(Date))=MonthEnd(max(Date)),MonthYear),MonthYear)