topic Re: Dimension based in another fields in QlikView

Dimension based in another fields

Wed, 25 Jun 2014 13:52:10 GMT

Hi.

I need to create a calculated dimension where, the dimension I need to use, is "controled" by the Year selected.

I have several dates in my system, but only one relates directly to Master Calendar. So I use Year (YYYY) in my list box, Month, etc..., from Master Calendar.

I have a chart where I need to use a dimension called DueDate (YYYY-MM), and its possible that this YYYY from DueDate doesn´t match Year from Master Calendar because they come from different fields.

I have another Year extracted from DueDate called YearDueDate (YYYY).

The point is that I need to use Year in selections, cause most data responds to it, but in some charts I need to use DueDate, where YearDueDate equals Year.

Example: RegistID=15201; Year=2014; DueDate=2013-10; YearDueDate=2013.

When I select Year=2014, my chart presents also this type of cases because they Year matches 2014, but in fact their DueDate is 2013.

I only want to show DueDate´s that match Year Selected.

Is this possible in calculated dimension, or another way? Till now couldn´t find a way by myself.

Thanks in advance.

Regards,

Bruno Silva.

Re: Dimension based in another fields

santharubban — Wed, 25 Jun 2014 14:26:26 GMT

it possible in set analysis, example: sum({<Year=,Year =YearDueDate >} abb)

this condition will will not select year even if u select year for particular chart.

Re: Dimension based in another fields

Wed, 25 Jun 2014 14:35:38 GMT

Thanks,

It didn´t work. Returns error message "No Data to Display".

But with your answer, I´ve tried something just a little bit different... In Set Analysis, I´ve added

"YearDueDate={$(vSelectedYear)}". This variable already existed in my system and returns Selected Year.

Thank you very much!

Best Regards,

Bruno Silva.