7 Replies Latest reply: Mar 21, 2016 5:01 PM by Jagveer Dhillon RSS

    Suppress a column based on dimension value

    Jagveer Dhillon



      I am new to qlikview, and so far the community threads have been a big help.

      I am stuck in a particular issue, where I have 2 dimensions (year and month) and 3 expressions (revenue, YoY change, %change)  in pivot table. Here month is on row level and year is on column level. and I have a list box for year to select any particular year.

      What I want to do here is based on the years selected, just display the YoY change and % Change for the most recent year, while the Revenue is displayed for each selected year.

      Any help is greatly appreciated.