topic Re: QTD Systax Issue : in QlikView

QTD Systax Issue :

Mon, 13 Jan 2014 17:55:29 GMT

Hi,

I 'm facing some wierd issue with QTD...Is there anything wrong in my syntax...Appreciate your help

if(wildmatch(only({1}CATEGORY_LABEL_SORT),20.5,24.5,21,0),'', Sum({$<PeriodID = {"<=$(=Max(PeriodID))"},QuarterID={"=$(=Max(QuarterID))"},FISCAL_YEAR=,FISCAL_QUARTER=,PeriodID=,PROJECT_NAME=>} DOLLAR_AMOUNT))

Re: QTD Systax Issue :

Nicole-Smith — Mon, 13 Jan 2014 18:02:51 GMT

Maybe try:

if(wildmatch(only({1}CATEGORY_LABEL_SORT),20.5,24.5,21,0),'', Sum({$<PeriodID = {"<=$(=Max(PeriodID))"},QuarterID={"$(=Max(QuarterID))"},FISCAL_YEAR=,FISCAL_QUARTER=,PeriodID=,PROJECT_NAME=>} DOLLAR_AMOUNT))

I removed the = from {"=$(=Max(QuarterID))"}.

Also, what do PeriodID and QuarterID actually look like? Are they numbers that you can use max() on?

Re: QTD Systax Issue :

Mon, 13 Jan 2014 18:26:10 GMT

((FISCAL_YEAR-1)*13) +FISCAL_PERIOD AS PeriodID,

((FISCAL_YEAR-1)*4) +FISCAL_QUARTER AS QuarterID,

Re: QTD Systax Issue :

Mon, 13 Jan 2014 18:27:28 GMT

Still i'm not getting an expected result...If we have two years 2013,2014...If the user clicks on 2013 Q3,it is showing all the data including 2014.

Re: QTD Systax Issue :

Nicole-Smith — Mon, 13 Jan 2014 18:29:49 GMT

Can you post a .qvw? I can't tell what's not working without actually seeing it.