topic Calculated dimension based on first field in QlikView

Calculated dimension based on first field

Anonymous — Tue, 09 May 2017 13:10:14 GMT

i have a table as attached. in the first column i have the months (Feb 2017, MArch 2017 etc) in the second column it comes up with Dec 2016 till date

can i get a simple solution to restrict the second column to display only from the value in column1.

for ex if the column1 displays Feb 2017, Column 2 should display Feb 2017, March 2017, April 2017 and not earlier than that.

kindly advice

Re: Calculated dimension based on first field

Sergey_Shuklin — Wed, 10 May 2017 05:48:15 GMT

Hello!

If column1 and column2 has a date format you can use this condition:

if(column2>=addmonths(column1,0) and column2<=addmonths(column1,2),column2,null()).

Remember that you already have a null value in column2 so you must modify it somehow, otherwise all rows that is not true for the condition above will be cumulate in the null-row.

Hope you find it usefull!

Re: Calculated dimension based on first field

Anonymous — Wed, 10 May 2017 05:50:45 GMT

Thanks Sergey , will try your suggestion