topic Quarter Field values should be Q1,Q2... in QlikView

Quarter Field values should be Q1,Q2...

Fri, 09 Nov 2012 17:29:48 GMT

Hello communtiy members,

I have created field Quarter, but I want the values to be in Q1,Q2...format...default values are 1,2,3.

please any one you help me

regards

Ramesh

Re: Quarter Field values should be Q1,Q2...

MayilVahanan — Fri, 09 Nov 2012 17:32:28 GMT

Try like this

'Q' & Ceil(Month(Date) / 3)

Hope it helps

Re: Quarter Field values should be Q1,Q2...

Fri, 09 Nov 2012 18:09:06 GMT

I am getting extra 'Q' Value

in fiield, can say where is the problem

q1,

q2,

q3,

q4,

in this manner

Re: Quarter Field values should be Q1,Q2...

MayilVahanan — Fri, 09 Nov 2012 18:11:21 GMT

For view in list box

=if(isnull(Quarter),'', 'Q'&Quarter)

but you want to create a field , you must want to load in script oly

Re: Quarter Field values should be Q1,Q2...

Fri, 09 Nov 2012 18:30:38 GMT

Hi ramasamy, can you please correct me why I am getting the q value, I am attaching my file please correct me,

and I have another problem also

I want to represent values the gauge charts, can you please correct me in this issue also

Regards

Ramesh

Re: Quarter Field values should be Q1,Q2...

Fri, 09 Nov 2012 18:48:58 GMT

Hi ramasamy,

I resolved the issue, I have the record, which contains a date of some 51, so it doesnot fall under these four quarters, it is defaultly taking another value as Q

regards,

ramesh

Re: Quarter Field values should be Q1,Q2...

MayilVahanan — Fri, 09 Nov 2012 18:58:45 GMT

You can use inline table for it..

Load * inline

[

Month,Quarter

Jan,Q1

Feb,Q1

Mar,Q1

...

Dec,Q4

];

Hope it helps..

So it avoid that issue.. i can't reload the script because of qvd n xls..