Conditional Dimension

[Anonymous]

Hi,

I have a question about enabling conditional dimension in qlikview.

I have year dimension that has value from 2010 until 2015,

I only want to show year 2013 until 2015, I've already try using enabling dimension in dimension tab and insert "Year>=2013 and Year<=2015" but it still show 2010 until 2015

What expression i must input in that column ?

thanks

Really appreciate your help

[Anonymous]

Hi Jonathan,

Sorry for the unclear statement.

I want to show only 2013 until 2015.

But when i choose specific year, let's say i choose 2013, i want to show only 2013. If i use expression the selection will not working.

Thanks

[#3]

Hi lejours,

I think you should go with Calculated Dimension and not for enable condition. As enable condition states on what selection you are enabling the dimension in the chart.

Click on Add Calculated Dimension and you can write the expression:

if(Year>='2013' and Year<='2015',Year)

Anjali Gupta

[Kushal_Chawda]

create a flag in script

if(Year>=2013,1) as YearFlag

Now create calculated dimension using set analysis

aggr(only({<YearFlag={'1'}>}Year)Year)

[jonathandienst · Accepted solution]

Then this may work:

     =Sum({$*<Year = {">=2013 <=2015"}>} Amount)

(intersection between section and current year)

Or this:

     =If(GetSelectedCount(Year) = 1,

          Sum(Amount),

          Sum({<Year = {">=2013 <=2015"}>} Amount)

     )

[ecolomer]

can you upload data file?

[Anonymous]

Adhoc reporting in Qlikview

Please check this .this may help you .

Thanks,

Bunny

[avinashelite]

can you please share a sample app with data so that we can check the same

[Anonymous]

Hi Jonathan,

Thanks for your suggestion,

It works perfectly