topic Re: Sort or Order a Set or a List in qlik sense in App Development

Sort or Order a Set or a List in qlik sense

danielerosa — Fri, 15 May 2020 17:09:38 GMT

How do I make this:

=concat(distinct [calwk_df.calwk], '|')

descending sorted by calwk_df.calwk?

sunny_talwar — Fri, 15 May 2020 17:19:57 GMT

Try this

=Concat(DISTINCT [calwk_df.calwk], '|', -[calwk_df.calwk])

danielerosa — Fri, 15 May 2020 17:24:27 GMT

Works great! Thank you.

Is there a way to check "live" the result of a function on the data loaded in the app? Something like a console.

sunny_talwar — Fri, 15 May 2020 17:28:37 GMT

I am not sure I follow your question? What exactly are you trying to follow while the app reloads?

danielerosa — Fri, 15 May 2020 17:37:04 GMT

I want a debugger for variable values as I am writing the set filtering/slicing expressions. Is there anything like that?

For example, now I have to:

get the 4 largest values from

calwk_df.calwk which are less or equal to a value that I specify (a variable in qlik sense) and stick that list into another variable

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

Then take everything from another dataframe, sales_df, where sales_df.calwk is in ${ref_month}.

filtered_sales_df = <sales_df where sales_df.calwk is in ${ref_month}>

I don't even know if it's possible to do this in qlik sense.

sunny_talwar — Fri, 15 May 2020 17:40:22 GMT

I don't think that there is a debugger, but I might be wrong because I don't use Qlik Sense very often. May be others can comment on this