topic Re: Current quarter in bar chart in QlikView

Current quarter in bar chart

arulsettu — Wed, 01 Apr 2015 10:21:13 GMT

hi,

i am having a bar chart with month dimension and in expression set analysis Quarter = Q4 it showing

oct,nov,dec. but i need if select another quarter the month should change according to the quarter

plz suggest some ideas

thanks

Re: Current quarter in bar chart

MK_QSL — Wed, 01 Apr 2015 10:22:28 GMT

Provide your expression please...

Re: Current quarter in bar chart

arulsettu — Wed, 01 Apr 2015 10:27:33 GMT

here it is

=sum({<ACNT_FLEX_01={'Expenses'},Td_Quarter={'Q4'},ACNT_FLEX_03={'Operative and administrative expenses'},TD_DRCR_FLAG={'D'}>}TD_AMT_LC_1)-sum({<ACNT_FLEX_01={'Expenses'},Td_Quarter={'Q4'},ACNT_FLEX_03={'Operative and administrative expenses'},TD_DRCR_FLAG={'C'}>}TD_AMT_LC_1)

Re: Current quarter in bar chart

MK_QSL — Wed, 01 Apr 2015 10:35:56 GMT

You have kept Q4 as static.. You need to make it dynamic by keeping Quarter = max(Quarter) or

QuarterStart(Date) and QuarterEnd(Date)... with combination of AddMonths function..

Re: Current quarter in bar chart

arulsettu — Wed, 01 Apr 2015 10:38:00 GMT

max(quarter) is not working can you tell me how to do with quarterstart and end

Re: Current quarter in bar chart

arulsettu — Wed, 01 Apr 2015 10:59:41 GMT

any ideas

Re: Current quarter in bar chart

rubenmarin — Wed, 01 Apr 2015 11:01:36 GMT

Hi Arul, instead of "Td_Quarter={'Q4'}" you can use:

Td_Quarter={'$(=MaxString(Td_Quarter))'}

If you want more than one quarter use something like:

Td_Quarter={'$(=Concat(Td_Quarter, Chr(39) & ',' & Chr(39)))'}

Re: Current quarter in bar chart

arulsettu — Wed, 01 Apr 2015 11:12:50 GMT

thanks Ruben i will check

Re: Current quarter in bar chart

Wed, 01 Apr 2015 11:22:27 GMT

Hey Arul ,

Try like this.....

dual('Quarter ' & ceil(month(Field)/3), ceil(month(Field)/3))AS DateFieldQuarter

'Q' & ceil(month(field)/3)

Re: Current quarter in bar chart

arulsettu — Wed, 01 Apr 2015 14:41:12 GMT

Hi Ruben,

if i select Q1 i am getting jan feb mar oct nov dec. i want jan feb mar that mean Q1 only

thanks

Re: Current quarter in bar chart

arulsettu — Wed, 01 Apr 2015 14:42:48 GMT

thanks its working can you tell me how maxstring works here

Re: Current quarter in bar chart

rubenmarin — Wed, 01 Apr 2015 14:47:27 GMT

Hi Arul, it returns the last value sorted alphabetically, it's the same than Max() but used for strings:

'Q1'<'Q2'<'Q3'<'Q4'

Re: Current quarter in bar chart

arulsettu — Wed, 01 Apr 2015 14:53:53 GMT

thanks