topic Re: quarter field in QlikView

quarter field

prma7799 — Tue, 27 Oct 2015 09:39:59 GMT

Hi All,

I have one requirement below .

I want one field that shows all quarter months like below.

(Apr 15-Jun 15)

(Jul 15-Sep 15)

(Oct 15-Dec 15)

(Jan 16-Mar 16)

How to achieve the same.

Thanks

Re: quarter field

MK_QSL — Tue, 27 Oct 2015 09:42:40 GMT

=Date(QuarterStart(Date(Today())),'MMM YY') & '-' & Date(QuarterEnd(Date(Today())),'MMM YY')

Use your DateField instead of Today()

Re: quarter field

sunny_talwar — Tue, 27 Oct 2015 09:43:29 GMT

May be add a field to your master calendar:

Date(QuarterStart(TempDate), 'MMM YY') & '-' & Date(QuarterEnd(TempDate), 'MMM YY') as Quarter

Re: quarter field

prma7799 — Tue, 27 Oct 2015 10:43:51 GMT

Hi Sunny,

Output is coming proper but when i am taking into that field in pivot table then values is not coming proper.

Thanks

Re: quarter field

sunny_talwar — Tue, 27 Oct 2015 10:46:39 GMT

By proper you mean that the value is sorted incorrectly? If that is the problem, try changing the above a little bit:

Dual(Date(QuarterStart(TempDate), 'MMM YY') & '-' & Date(QuarterEnd(TempDate), 'MMM YY'), QuarterStart(TempDate)) as Quarter

Re: quarter field

prma7799 — Tue, 27 Oct 2015 10:54:09 GMT

I tried but not come right info..

When i select particular month then values will come.

see the attached ...

Re: quarter field

MK_QSL — Tue, 27 Oct 2015 11:05:06 GMT

I don't think you are getting wrong result.. Check that Jan to Mar is for 2013 when you are selecting 2012-2013..!

Re: quarter field

sunny_talwar — Tue, 27 Oct 2015 11:05:21 GMT

Which value isn't coming? I am not sure which object are you talking about? Can you give more details please.

Re: quarter field

sunny_talwar — Tue, 27 Oct 2015 11:30:14 GMT

Those are different ORD_CUSTCODE. I am 100% sure that if you scroll down the chart you will see a value next to APS041 even when you don't have anything selected.

Update: Look at the attached image

Re: quarter field

prma7799 — Tue, 27 Oct 2015 11:33:18 GMT

Hey Sunny,

You are right...

But if i will get any difficulties regarding same then i will reply you on same discussion .

thanks

Re: quarter field

sunny_talwar — Tue, 27 Oct 2015 11:34:23 GMT

Not a problem. I would suggest creating a new discussion thread for a new problem. That way your post will receive greater exposure.

Re: quarter field

prma7799 — Tue, 27 Oct 2015 11:35:57 GMT

okies