6 Replies Latest reply: Aug 13, 2015 4:28 AM by Andy Weir RSS

    Date Picker in Qlik sense #Qwidget

    Satish Pawar

      Hi Community,

       

      I'm working in Qwidget for Date Picker object.

      i also created start_date and End_date objects.

       

      BUT there is no association between data and these object whenever i select date range it doesn't effect on dashboards.

      where is mistake?

       

       

      data:

      Load

      year(txn_time) as "Year",

      month(txn_time) as "Month",

      WeekDay("txn_time") as DayN,

      date(txn_time,'DD-MM-YYYY') as Date,

      timestamp(txn_time,'DD-MM-YYYY hh:mm:ss') as "Timestamp",

      "txn_time"

      FROM [lib://QVD/IOT_TXT_RAW.QVD]

      (qvd)

      ------------------------------------------------------------------------------------------

      CalendarTemp:

      LOAD

          Max(date(txn_time,'DD-MM-YYYY'))AS DateMax,

          Min(date(txn_time,'DD-MM-YYYY'))AS DateMin

          RESIDENT data;

       

       

      LET vMaxDate = FieldValue('DateMax', 1);

      LET vMinDate = FieldValue('DateMin', 1) -1;

       

       

      DROP TABLE CalendarTemp;

       

       

      let vStartDate = Date('$(vMinDate)');

      let vEndDate = Date('$(vMaxDate)');

       

       

      let vYesterday = date(vMaxDate)-1;