6 Replies Latest reply: Oct 11, 2018 10:46 AM by manoj kumar RSS

    Select a string through calender object

    manoj kumar

      Capture.JPG

      Hi all,

       

      I have a calender object and it  is working fine when i select a date it will shows the data based on our current selections but some date values are missing so i replaced with string like 'no data' now when i select a data it need to show the data based on selections and string as well.

       

      please suggest

        • Re: Select a string through calender object
          Sunny Talwar

          Where exactly have you added 'no data'? I don't see this in your screenshot above

            • Re: Select a string through calender object
              manoj kumar

              i am created calender object for the date range selection it is working fine but i have some null values in date field

              so replaced with No Date

              user asked when he selects a date range it should select data with his selections and No date values also

                • Re: Select a string through calender object
                  Marcus Sommer

                  It won't be possible unless you could give them any date between the choosen min/max-date of your calendar - maybe with something like: dual('no data', floor(yearstart(today()))). Otherwise these values belong not to the selection.

                   

                  Are you really sure that it make sense to display these NULL's (after replacing with any selectable value) in the context of the data which have a date? If so you will need a logic which select/displayed the dates AND the 'no data' - maybe by using a separate calendar-field which triggers the appropriate date-selection in the real field AND makes a toggle-select to the 'no data'. An alternatively could be to use set analysis within the expressions maybe with something like this:

                   

                  sum({< date *= {'no data'}>} value)

                   

                  - Marcus

                    • Re: Select a string through calender object
                      manoj kumar

                      Thanks Marcus for your reply.

                       

                      Do you have any proof i have to show my user.

                      qlik product has mentioned this any where in any document. if you have any details with you please share with me.

                       

                      Please let me know if any possibilities are there for my requirement.

                       

                      Thanks for your help.

                        • Re: Select a string through calender object
                          Marcus Sommer

                          I'm not sure what do you mean with 'proof'. If the replacement of any NULL's aren't within the dataset which the user selects the belonging values/records aren't included - it's just the way Qlik works (intentionally).

                           

                          Above I showed 3 different ways with which you might bypass the standard-logics. This are replacing the NULL's with an estimated value which is probably between the user-selections or a selection-trigger or with set analysis conditions within the expressions.

                           

                          And the easiest way would be just to use a listbox as selection-tool instead of a calendar object - the user just selects the wanted dates and the 'no data' ...

                           

                          - Marcus

                            • Re: Select a string through calender object
                              manoj kumar

                              proof means any document from Qlik like reference document, developer cookbook.

                               

                              Initially Qlik will document their limitations and best practices like have any documented points.

                               

                              Because user is saying qlik is a big tool why it will not support these. so i need to show some proof.

                               

                              But thanks for your support. its a great help to me.