4 Replies Latest reply: Dec 19, 2017 10:22 PM by eric nieto RSS

    QLIKSENSE FILTER AND QUERY ON THE FLY

    eric nieto

      Hi Everyone,

       

      Can you help me on this one please? I wish to filter the ORDER based on the values from two fields; INTERVAL(PREV-REC) and      INTERVAL(REC-NEXT).


      RECORDS:

      ORDER        ORDER DATE          INTERVAL(PREV-REC)        INTERVAL(REC-NEXT)

      A                  16/5/2016                   -                                            28

      B                  13/6/2016                  28                                          32

      C                   15/7/2016                  32                                        34

      D                  18/8/2016                  34                                         35

      E                  22/9/2016                  35                                         22

      F                  14/10/2016                22                                           27

      G                  10/11/2016                27                                         41

      H                  21/12/2016                41                                         36

      I                  26/1/2017                    36                                         47

      J                  14/3/2017                  47                                            -


      Say I want to filter and only display ORDER where the interval = 22. This would mean that only ODER E and ORDER F will be shown.

      and if I filter for interval = 27, ORDER F and ORDER G will be shown. and so on...


      The filter is dynamic, hence what i did is i defined an inline table. and then

      Table:

      Load*Inline [

      DAYS

      1

      2

      3

      4

      5

      6

      7

      8

      9

      10

      ...

      .....

      50

      ];

       

      Thought i could use the function GetFieldSelections() but I couldn't make it work. please help advise if this is possible. Many thanks in advance!

       

      ordercap.PNG