topic Re: getting Column names based on loop in QlikView

getting Column names based on loop

Kanstussy — Fri, 25 Oct 2019 15:37:21 GMT

I am loading Quantity from a table. Quantity field is sequencial as shown below.

LOAD
Q_REL_SUPLR_MO_1,
Q_REL_SUPLR_MO_2,
Q_REL_SUPLR_MO_3,
Q_REL_SUPLR_MO_4,
Q_REL_SUPLR_MO_5,
and so on

Requirement is to load fields based on the current month. For example if current month is October then it should Mo1,Mo2 and Mo3. if current month is nov then Mo1 and Mo2

Re: getting Column names based on loop

Frank_Hartmann — Fri, 25 Oct 2019 18:56:19 GMT

maybe something like this:

LET actualmonth = num(month(MonthName((now()))- 1*12)); Test: Load *, subfield(Field,'_',5) as subfield; Load * inline [ Field Q_REL_SUPLR_MO_1, Q_REL_SUPLR_MO_2, Q_REL_SUPLR_MO_3, Q_REL_SUPLR_MO_4, Q_REL_SUPLR_MO_5 ] where $(actualmonth)<= 12-subfield(Field,'_',5);

Re: getting Column names based on loop

raghuchowdary — Fri, 25 Oct 2019 20:25:09 GMT

Do you want to show in a straight table?

In a simple way , add columns for each field and add " show column "conditions based on the months accordingly.

If your requirement is different , please explain more clearly.