Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Not applicable

Sort in Graph

Hi All,

I want to put interactive sort on my Chart.

And color those arrows for chart sort.

this sort should work ascending and descending as well.

1 Solution

Accepted Solutions
Employee
Employee

Re: Sort in Graph

What I´ve done

1) Created one variable vSort

2) Created one textbox, configurated as image and with this expression:

=if(vSort=1,'qmem://<bundled>/BuiltIn/arrow_n_r.png',

if(vSort=2,'qmem://<bundled>/BuiltIn/arrow_s_r.png',

'qmem://<bundled>/BuiltIn/arrow_e.png'))

3) Attached one action "Set Variable" with expression =if(vSort=1,2,1)

4) Created one textbox, configurated as image and with this expression:

=if(vSort=3,'qmem://<bundled>/BuiltIn/arrow_n_r.png',

if(vSort=4,'qmem://<bundled>/BuiltIn/arrow_s_r.png',

'qmem://<bundled>/BuiltIn/arrow_e.png'))

5) Attached one action "Set Variable" with expression =if(vSort=3,4,3)

6) Created one textbox, configurated as image and with this expression:

=if(vSort=5,'qmem://<bundled>/BuiltIn/arrow_n_r.png',

if(vSort=6,'qmem://<bundled>/BuiltIn/arrow_s_r.png',

'qmem://<bundled>/BuiltIn/arrow_e.png'))

7) Attached one action "Set Variable" with expression =if(vSort=5,6,5)

8) Used this expression as Sort Order of my table

Pick(vSort,

-sum(Expression1),

sum(Expression1),

-sum(Expression2),

sum(Expression2),

-sum(Expression3),

sum(Expression3)

)

Capturar.PNG.png

Capturar2.PNG.png

Capturar3.PNG.png

Capturar4.PNG.png

3 Replies
Employee
Employee

Re: Sort in Graph

Please check if fits your needs.

You can improve layout later

Not applicable

Re: Sort in Graph

Actually I am using Personal Edition.

Employee
Employee

Re: Sort in Graph

What I´ve done

1) Created one variable vSort

2) Created one textbox, configurated as image and with this expression:

=if(vSort=1,'qmem://<bundled>/BuiltIn/arrow_n_r.png',

if(vSort=2,'qmem://<bundled>/BuiltIn/arrow_s_r.png',

'qmem://<bundled>/BuiltIn/arrow_e.png'))

3) Attached one action "Set Variable" with expression =if(vSort=1,2,1)

4) Created one textbox, configurated as image and with this expression:

=if(vSort=3,'qmem://<bundled>/BuiltIn/arrow_n_r.png',

if(vSort=4,'qmem://<bundled>/BuiltIn/arrow_s_r.png',

'qmem://<bundled>/BuiltIn/arrow_e.png'))

5) Attached one action "Set Variable" with expression =if(vSort=3,4,3)

6) Created one textbox, configurated as image and with this expression:

=if(vSort=5,'qmem://<bundled>/BuiltIn/arrow_n_r.png',

if(vSort=6,'qmem://<bundled>/BuiltIn/arrow_s_r.png',

'qmem://<bundled>/BuiltIn/arrow_e.png'))

7) Attached one action "Set Variable" with expression =if(vSort=5,6,5)

8) Used this expression as Sort Order of my table

Pick(vSort,

-sum(Expression1),

sum(Expression1),

-sum(Expression2),

sum(Expression2),

-sum(Expression3),

sum(Expression3)

)

Capturar.PNG.png

Capturar2.PNG.png

Capturar3.PNG.png

Capturar4.PNG.png

Community Browser