User defined sorting

Chandu — Mon, 06 Mar 2023 05:59:47 GMT

Hi All,

I'm trying to create a user defined sorting. I have created 2 variables with name Vexpression and Vsorting. In Vexpression I have taken a variable input and in variable I have taken the Vexpression variable and in value sum(totalamount) and I have taken another variable input in that I have selected the variable Vsorting and in shows as drop down and in value for ascending (1) and for descending (-1) and I have taken a bar chart with dimension patientnumber and measure as sum(totalamount) in sorting I have disabled all the options and the dimensions which I used as patient number in that I have selected sort by expression and I have given expression as =$(Vexpression)*Vsorting but it is showing an error as garbage after expression Vsorting.

I tried to use $((Vexpression)*Vsorting) there is no error but my sorting option is not working

Please help me to solve this issue.

Thanks in advance 🙂

Re: User defined sorting

marcus_sommer — Mon, 06 Mar 2023 12:50:26 GMT

The call of $((Vexpression)*Vsorting) isn't valide. You may try it in this way: $(Vexpression) * $(Vsorting)

Re: User defined sorting

Chandu — Mon, 06 Mar 2023 18:01:06 GMT

Thanks Marcus it's working 👍

topic User defined sorting in App Development

User defined sorting

Re: User defined sorting

Re: User defined sorting