topic Re: List Box Issue in Function in QlikView

List Box Issue in Function

mhmmd_srf — Wed, 25 Nov 2020 16:16:04 GMT

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 — Wed, 12 Apr 2017 08:57:51 GMT

May be using firstsortedvalue() function??

sunny_talwar — Wed, 12 Apr 2017 09:44:58 GMT

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 — Wed, 12 Apr 2017 09:50:52 GMT

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;