List Box Issue in Function

[mhmmd_srf]

Hi All,

I have an requirement to show Week No along with Week StartDay.

But Week is Fiscal Week and Start Date is Calendar Date in DB like below:

In Qlik Also it is showing same way.

But I want to pick up the first Value of min Value of date.

So in Week-Date list box it should only show 3(10/9/2016).

Can u please check and suggest how to do this. I tried to use min function in List Box expression. It did not work

I am attaching my qvw file.

Thanks,

Sarif

[Anonymous]

May be using firstsortedvalue() function??

[sunny_talwar]

How about doing it this way where you add expression on the expressions tab and use a single fiscalweek field for your list box field

UPDATE: Updated the sample because of some error before

[avkeep01]

Hi Mohammad,

Maybe you can add an extra left join in the script where you flag the first value. That would be something like;

LEFT JOIN (DIM_DATE) LOAD

DIM_DATE.CstFiscalYear,

DIM_DATE.CstFiscalWeek,

MIN(DIM_DATE.CstWeekBeginDate) AS DIM_DATE.CstWeekBeginDate,

1 AS DIM_DATE.MIN_Date

RESIDENT DIM_DATE;