Skip to main content
Announcements
See why Qlik was named a Leader in the 2024 Gartner® Magic Quadrant™ for Data Integration Tools for the ninth year in a row: Get the report
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Is it possible with this problem?

hi guys..i have the problem like this

date     place     value

  2          a          3

  4          a          2

  3          b          9

  6          b          3

the result is

date     place     value

  2          a          3

  3          a          3

  4          a          2

  5          a          2

  6          a          2

  3          b          9

  4          b          9

  5          b          9

  6          b          3

how to implement that?

thanks

1 Reply
Not applicable
Author

Hey There,

You could try the below:

In the Script:

"Main":

Load *

;

SQL SELECT

           date,

          place,

          value

from yourtable

order by date, place desc

;

Then on the front end create a table box and add the date,place and value fields.

Hope it helps,

Regards GJ.