topic Filter out dimension based on selection in QlikView

Filter out dimension based on selection

hkapadia — Wed, 07 Feb 2018 19:52:53 GMT

Hello,

I have a straight table where fields Year1 & Month1 are my dimensions. I have a filter with fields Year2 & Month2. What I am trying to show in the table is only values from Month1 field where Year2 filter selection = Year1. In my data model, I load completed month data for current year and the past year. If the filter Year2 is 2018 then my straight table dimension should only show Jan as the only completed month so far, if the filter Year2 is 2017 then my straight table dimension would display all 12 months. Is it possible to do this?

Re: Filter out dimension based on selection

sunny_talwar — Wed, 07 Feb 2018 20:00:10 GMT

Year1 and Year2 are different fields? or it's just you calling them different names because they are from different objects?

Re: Filter out dimension based on selection

hkapadia — Wed, 07 Feb 2018 20:11:32 GMT

They are different fields

Re: Filter out dimension based on selection

sunny_talwar — Sun, 11 Feb 2018 01:44:13 GMT

May be this

{<Year1, Year2 = p(Year1)>}

Re: Filter out dimension based on selection

hkapadia — Mon, 12 Feb 2018 22:30:54 GMT

I am using Calculated Dimension & I used

=only({<Year1, Year2=P(Year1)} Month2)

as the expression as I only want to show months for the year selected in Year1. This is giving me 'Error in calculated dimension'.

Re: Filter out dimension based on selection

sunny_talwar — Mon, 12 Feb 2018 23:51:09 GMT

May be this

Aggr(Only({<Year1, Year2 = P(Year1)}>} Month2), Month2)

Re: Filter out dimension based on selection

hkapadia — Tue, 13 Feb 2018 18:53:44 GMT

Thanks Sunny. That worked.