Sort or Order a Set or a List in qlik sense

[danielerosa]

How do I make this:

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

descending sorted by calwk_df.calwk?

[sunny_talwar · Accepted solution]

Try this

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

[danielerosa]

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]

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

[danielerosa]

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]

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