Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

berryandcherry6
Contributor II

How to make filter to show data in descending order

Hi all,

I have created a filter where it showing data in Asending order. How could i make it to show in  descending order.

Regards,

Supriya

Tags (1)
1 Solution

Accepted Solutions
arulsettu
Honored Contributor III

Re: How to make filter to show data in descending order

try like this

Untitled.png

13 Replies
arulsettu
Honored Contributor III

Re: How to make filter to show data in descending order

in sort there is desc order.did you tried that?

vikasmahajan
Honored Contributor III

Re: How to make filter to show data in descending order

Create Straight table with interactive sort option no need to create additional filters , you can double click on column will sort ascending / descending both way.

Vikas

berryandcherry6
Contributor II

Re: How to make filter to show data in descending order

Hi,

Thanks for reply

I tried Changing to descending in sorting its not changing.

In script

-------------

LOAD

    `tips_id`,

    tips_id &'-'& `subject_header` as subject_header;

SQL SELECT

    `quick_tips_id`,

    `subject_header`

FROM TIPSTEXT

In Filter Dimension

------------------

subject_header

Please help me in this regard.

berryandcherry6
Contributor II

Re: How to make filter to show data in descending order

Hi,

Thanks for reply

It has to be done in filter itself. I tried changing in sorting option also its not getting changed.

Please help me on this regard.

arulsettu
Honored Contributor III

Re: How to make filter to show data in descending order

can you post sample qvf

berryandcherry6
Contributor II

Re: How to make filter to show data in descending order

HI.

Please check attached file.

Please help me in this.

Regards

Supriya

berryandcherry6
Contributor II

Re: How to make filter to show data in descending order

Hi vikas,

Please check attached file

Regards,

Supriya

arulsettu
Honored Contributor III

Re: How to make filter to show data in descending order

what is your expected output?

arulsettu
Honored Contributor III

Re: How to make filter to show data in descending order

like this?

Untitled.png