data slicing

[danielerosa]

I want to store the 4 largest values less than a specified value from:

calwk_df.calwk

example:

ref_month = <list of largest calwk_df.calwk which are less or equal to ${calwk}>

into a variable and use that variable to filter a dataframe:

example:

new_df = <old_df where old_df.calwk in ${ref_month}>

where ref_month is a list

[pedrobergo]

Hi @danielerosa ,

Seems that you using a R or Python structures. There is no dataframes and lists inside Qlik, it has tables, columns, fields and expressions. All the data are stored in memory, and you use the expressions to create formulas that represent your data.

Well, I guess you need to get the four weeks of a calendary in a given month, but you wanna use it inside Qlik Script or Chart / Table function?

I suggest you to create a master calendar and use Set Analysis to filter your data inside formulas. See these link and tell me if its solve your needs https://qlikviewcookbook.com/2015/05/better-calendar-scripts/

[],

Pedro

[danielerosa]

Thank you, Pedro.

I am probably going to use another tool.