Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all!
I'm new here, I really need your help.🖐
I have a source table with 3 dimensions
Date1 | Product | Value |
31.01.2023 | D | 15 |
30.01.2023 | C | 0 |
31.01.2023 | C | 10 |
31.01.2023 | B | 0 |
28.01.2023 | B | 0 |
31.01.2023 | A | 0 |
29.01.2023 | B | 5 |
27.01.2023 | B | 10 |
30.01.2023 | A | 12 |
My goal is to sort it like this
Date1 | Product | Value |
31.01.2023 | A | 0 |
31.01.2023 | B | 0 |
30.01.2023 | B | 0 |
30.01.2023 | C | 0 |
29.01.2023 | A | 0 |
28.01.2023 | A | 0 |
31.01.2023 | B | 15 |
31.01.2023 | C | 10 |
30.01.2023 | D | 20 |
So that zeros are at the top, sorted by date in descending order and product alphabetically, all other values are also sorted by date in descending order and product alphabetically.
I know it can be done with a hidden column, but my goal is not to use an extra column.
When I sort by value expression I don't get what I want
Not all dates are descending
I want to get this result
I attach an example qvw
It seems like it should be very simple, but I can't find a solution.
I would appreciate any help 🙏
@AleksandrShergin in Sort Property, do the sorting in below order. see the attached
1) Value -> Numeric ascending
2) Date -> Numeric descending
3) Product -> Text A-Z
Thanks for the answer, but it gives the following result
![P3.png P3.png](https://community.qlik.com/t5/image/serverpage/image-id/104025i1A1C88073F5C74C1/image-size/large?v=v2&px=999)
When the zeros run out, the dates are inconsistent.
I need this result