topic Re: RE:Negative quarters in QlikView

RE:Negative quarters

Chanty4u — Sun, 03 Apr 2016 08:33:59 GMT

Hi all,

I have issue on Quarters

As i am getting negative Quarters in my Dashboard.

in listbox

i have yearquarter field.

in that it is displaying

-Q1

-Q2

2014 -Q1

2014-Q2

lik dat it is showing?

what is the reason? and i dont want that Quarterfields which is in negative.. i just want yearquarter only.

Thanks in Advance

Re: RE:Negative quarters

Kushal_Chawda — Sun, 03 Apr 2016 08:44:01 GMT

How you are creating quarter?

Re: RE:Negative quarters

Chanty4u — Sun, 03 Apr 2016 10:15:08 GMT

kush,

Rejection:

LOAD

WHEAT_REJ_YEAR &'-'& WHEAT_REJ_QUATER As WHEAT_REJ_QUATERYEAR,

From $(vQVDTargetDir)ZREJ_TRACWHEAT.qvd(qvd) where WHEAT_REJ_DATE<='30/12/2016' and WHEAT_REJ_DATE<=Date('31/08/2015') ;

Note: Wheat_RejectQuarteryear filed value showng negative in listbox.

Re: RE:Negative quarters

Kushal_Chawda — Sun, 03 Apr 2016 10:20:47 GMT

I think there are some blank values in your WHEAT_REJ_YEAR field that is why some values are -Q1.. it's not actually minus but '-' hyphen. also try to change your where like below

WHEAT_REJ_DATE <=date#('30/12/2016','DD/MM/YYYY') and WHEAT_REJ_DATE >=Date#('31/08/2015','DD/MM/YYYY') ;

Re: RE:Negative quarters

HirisH_V7 — Sun, 03 Apr 2016 10:30:21 GMT

Hi,

What are fields of ,

WHEAT_REJ_YEAR

WHEAT_REJ_QUATER

WHEAT_REJ_DATE

Look like?

-Hirish

Re: RE:Negative quarters

sunny_talwar — Sun, 03 Apr 2016 10:35:08 GMT

I guess you can do this:

If(Len(Trim(WHEAT_REJ_YEAR)) > 0, WHEAT_REJ_YEAR &'-'& WHEAT_REJ_QUATER) as WHEAT_REJ_QUATERYEAR,

This will only create this new WHEAT_REJ_QUATERYEAR field when WHEAT_REJ_YEAR will have a value

Re: RE:Negative quarters

Chanty4u — Sun, 03 Apr 2016 10:51:44 GMT

rej_year

2014

2015

2016

rej_date

31-08-2014

01-09-2014 lik so on