0 Replies Latest reply: Sep 25, 2017 11:33 AM by Joshua Hounsome RSS

    Suppressing Nulls in Cyclic Dimensions

    Joshua Hounsome

      Hi Guys,

       

      I have been using Qlikview for a year but am new to QlikSense.

       

      I have created two cyclic dimensions that both appear in a pivot table, but I am having issues formatting them how I want.

       

      The cyclic dimensions are created using:

       

      [Concat_Cycles]:

       

      load * inline [

      Concat, Cgroup_Start, Cgroup_End

      Filter1, prod1_start, prod1_end
      Filter2, prod2_start, prod2_end
      Filter3, prod3_start, prod3_end


      ];

       

       

       

      This successfully creates the cyclic dimensions, creating a table with dimensions:

      Date, prod(x)_start, prod(x)_end, count(customers), sum(revenue).

       

      But, there are two issues.

       

      (1) Logically, the x associated to the prod(x)_start and prod(x)_end will always be the same. I wanted to use Filter(x) in order to have just one filter pane for this but it does not work. Is there another work around?

       

      (2) I am receiving lines where both "prod" fields are completely NULL or empty. If both of these fields are NULL or empty I do not want to show results. I have tried using a len(trim()) within my pick(match()) clause with no luck. Any solution for this?

       

      I appreciate this is a very wordy question, but I attempted to trawl through forums to no avail!

       

      Thanks

      Josh