topic Re: Dynamically Assign M1 , M2, M3 dynamically to certain time period in qlik sense in App Development

Dynamically Assign M1 , M2, M3 dynamically to certain time period in qlik sense

Vichuf1 — Sat, 16 Nov 2024 05:05:41 GMT

Dynamically Assign M1 , M2, M3 to certain time period in qlik sense

(Here M1 , M2, M3 are months )

How can add calculated column to get the expected result as shown below:

Table:

Expected result Column 6 "Calculated field"

Frank_Hartmann — Thu, 01 Aug 2019 14:53:06 GMT

see attached qvw.

---------------------------------------------------------------------------------

Table:
LOAD RowNo() as Row,
[Season ID],
[Start Year],
[End year],
[Season month],
[Season Month year],
'M' & Autonumber([Season Month year],[Season ID]) as Test
FROM
[https://community.qlik.com/t5/Community-Corner/Dynamically-Assign-M1-M2-M3-dynamically-to-certain-time-period/td-p/1608527]
(html, codepage is 1252, embedded labels, table is @1) ;

-------------------------------------------------------------------------------------

Vichuf1 — Thu, 01 Aug 2019 19:20:47 GMT

Thank a lot Frank, that works perfectly for my scenario , You saved my day 🙂