topic Re: Conditional Dimension in QlikView

Conditional Dimension

Anonymous — Mon, 12 Oct 2015 05:04:44 GMT

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

Re: Conditional Dimension

ecolomer — Mon, 12 Oct 2015 05:07:06 GMT

try with:

year >= 2013

Re: Conditional Dimension

qlikviewwizard — Mon, 12 Oct 2015 05:10:59 GMT

Hi lejours88 ,

Try Enrique advise.

Re: Conditional Dimension

Anonymous — Mon, 12 Oct 2015 05:11:51 GMT

Hi, Enrique.

Unfortunately it still not working.

Do you have any idea ?

Thanks

Re: Conditional Dimension

Anonymous — Mon, 12 Oct 2015 05:13:08 GMT

Hi Arjun

i've try Enrique idea but still not working ?

do you have any idea ?

Re: Conditional Dimension

jonathandienst — Mon, 12 Oct 2015 05:20:32 GMT

The conditional is to either display or hide the entire dimension. I think what you want is to limit the chart to 2013-2015. For this you can use a calculated dimension with a filter on the dimension, but usually the best way (performance wise) is to use a set expression on the chart expressions. Something like

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

Adjust to suit your specific requirements.

Re: Conditional Dimension

Anonymous — Mon, 12 Oct 2015 05:33:29 GMT

Hi Jonathan,

I've try put it in the chart expression, but it doesn't meet my requirement, I can't select specific year. Because it always locked from 2013 and 2015 (always show data 2013 until 2015) When i choose 2013 it still show 2013 until 2015. So i want to try using conditinal dimension in dimension tab. Any idea ?

Re: Conditional Dimension

Kushal_Chawda — Mon, 12 Oct 2015 05:34:47 GMT

Create calculated dimension

aggr(if(Year>=2013,Year),Year)

Re: Conditional Dimension

jonathandienst — Mon, 12 Oct 2015 05:42:38 GMT

>> I can't select specific year.

Your original question was "I only want to show year 2013 until 2015".

So which years do you want to display? and how would you like it to react when you select 2013? Do you mean the two years prior to the selected year?

We can only answer the question you ask.

Re: Conditional Dimension

Anonymous — Mon, 12 Oct 2015 05:43:48 GMT

Hi Kush,

Thanks for your idea

But it will affect my loading time if i use calculated dimension.

Because i have many data and it will take long time.

Do you have another suggestion ?

Thanks in advance

Re: Conditional Dimension

Anonymous — Mon, 12 Oct 2015 05:50:17 GMT

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

Re: Conditional Dimension

Mon, 12 Oct 2015 05:51:31 GMT

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

Re: Conditional Dimension

Kushal_Chawda — Mon, 12 Oct 2015 05:55:12 GMT

create a flag in script

if(Year>=2013,1) as YearFlag

Now create calculated dimension using set analysis

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

Re: Conditional Dimension

jonathandienst — Mon, 12 Oct 2015 05:57:58 GMT

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)

)

Re: Conditional Dimension

ecolomer — Mon, 12 Oct 2015 06:07:59 GMT

can you upload data file?

Re: Conditional Dimension

Anonymous — Mon, 12 Oct 2015 06:45:41 GMT

Adhoc reporting in Qlikview

Please check this .this may help you .

Thanks,

Bunny

Re: Conditional Dimension

avinashelite — Mon, 12 Oct 2015 06:58:36 GMT

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

Re: Conditional Dimension

Anonymous — Mon, 12 Oct 2015 09:11:00 GMT

Hi Jonathan,

Thanks for your suggestion,

It works perfectly