Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

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

Is it possible with this problem?

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.

Community Browser