how to show ascending and descending

[kunkumnaveen]

Hello guys,

my client looking some weird kind of requirement ...what he want is

In the  straight table he wants sorting options(ascending and descending) for first four columns  ....

what i mean is

my first column is :Supplier Name  ..............for this he want ascending and descending option,by selecting any one option the entire row should get reflect ..

same  thing should repeat for the rest of three columns .....how to achieve this

please find the attachment (sample data)

[vikasmahajan]

Have you try with interactive sort ?

[Kushal_Chawda]

see the below link. Same approach you can follow for straight table

Perfectly Sorting Pivot Table (by A-Z. y-Value set for each dim-level)

[kunkumnaveen]

HI,

I have no clue about this interactive sort......how to implement it in qlikview

[Digvijay_Singh]

Don't know what do you mean, In straight table sorting option is already available. Double click the header of column to sort the column.

[awhitfield]

Hi Naveen,

Interactive sort is on the sort tab:

Enable it for the required DIMENSIONS and Expression, then just double click on the column headers

Andy

[kunkumnaveen]

Hi,

to make it simple on each column he need two options

1.ascending

2.descending ..that's it

[kunkumnaveen]

HI

I think i got the answer,but i need to find out whether he will satisfy  r not with this double click thing

thanks

[Digvijay_Singh]

You are Right, it is already there in straight table.