3 Replies Latest reply: Sep 19, 2017 8:48 PM by Sunny Talwar RSS

    Dimension as a function of filter

    Bohemia Group

      Hi,

       

      apologies if this question was raised/answered elsewhere. Did not find it by googling.

       

      Setup:

      1) Filter (acting as a drop down) with possible options:

      SEL1

      - Month

      - Week

      - Dat

       

      2) 2x charts which have dimensions setup as a function of SEL1:

      = if(SEL1 = "Month", date.Month, date.Day)

       

      where date.Month and date.Day are 2 separate variables/columns with Month and Day respectively.

       

      Problem:

      I get an error "cyclical link" and an app essentially freezes.

       

      Question:

      Is there any way how to implements conditional dimension in Qlik Sense Cloud?

       

      Any ideas how to implement it in Qlik Sense Cloud would be highly appreciated!

       

      Warm regards,

        Alex

      P.S. Let's please ignore the cases when multiple values are chosen in SEL1.