I am new to Qlikview, and desperately need some help on an issue that I am having with sorting.
I have a calculated field that is basically an AND function, so like A1&A2 if it was an excel function. I want to sort this new calculated field by the values that it shows, but I am not sure how to do that with the Match() sorting functionality. Is there any way that I can do that or do I need to do it in another way?
Hi Claus, welcome to QV!!! I would recomend using a straight table chart instead of a normal table for starters. By using the chart table, you get a lot more options to play about with, including a detailed sort section where you can determine what gets sorted first, and also where you can define what data type the concatenation is that you are sorting by, eg text, numeric etc. To add the table chart:
Right Click sheet, add sheet object, chart
Select straight table
Add your dimension
add your expression =A1&A2 (this is a string concatenation rather than a calculation)
then make sure the expression field is above the dimension field in the sort settings,
Hey Presto, your done!
If that hasn't answered your query, you can always post an example that I or others can help you with!
