3 Replies Latest reply: Jan 14, 2017 12:53 AM by Prasant Tata Branched from an earlier discussion. RSS

    Default month filter on Sense application

    Chinna Reddy

      Do we need to create a variable

      and i am having an field MonthDate which consists of 6 months and i wanted to show one specific month in my default selections how can i create the variable and apply it on the field?

        • Re: Default month filter on Sense application
          Michael Tarallo

          Hi Chinna - you do not need to create a variable if using Set Analysis - check out this video first:

           

          Introduction to Set Analysis (video) - Part 1

           

          and let me know if you still require assistance. I will attach a sample for you too.

           

          Please mark the appropriate replies as CORRECT / HELPFUL so our team and other members know that your question(s) has been answered to your satisfaction.

           

          Regards,

          Mike Tarallo

          Qlik

          • Re: Default month filter on Sense application
            Michael Tarallo

            Here is an example -

             

            This Month's Sales - using the month value of March or Mar as a string or literal value in the Set Analysis Expression:

             

            Sum({$<Month={'Mar'}>}Sales)

             

            This example shows an example of Dynamic Set Analysis - using the Month() and Today() functions to get the current month automatically or dynamically.

             

            Sum({$<Month={'$(=Month(Today()))'}>}Sales)

             

            When using function within expressions for the modifier you need to surround the expression like this:
            $(= some_expression() )

             

            Sum({$<Month={'$(=Month(Today()))'}>}Sales)

             

            This expansion syntax allows functions to be evaluated in the Set Analysis Expressor for search and comparison etc.

             

            Please mark the appropriate replies as CORRECT / HELPFUL so our team and other members know that your question(s) has been answered to your satisfaction.

             

            Regards,

            Mike Tarallo

            Qlik

              • Re: Default month filter on Sense application
                Prasant Tata

                Hi Mike,

                 

                I have gone through your post and it was really helpful.

                 

                I have a query, Set analysis you mentioned above works fine at the chart level when you have sales. I am stuck with different problem and need your inputs on this.

                 

                I have a Date filter with some 12 weeks in it and user wants to have default selection as Max(week) in the filter when he opens the app.I am using web version of qliksense and couln't find anything.

                 

                Is there any work around for this?

                 

                Thanks,

                Prasant Tata