Solved: Calculated dimension based on first field - Qlik Community

Anonymous · ‎2017-05-09

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

Sergey_Shuklin · ‎2017-05-10

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!

View solution in original post

Sergey_Shuklin · ‎2017-05-10

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!

Anonymous · ‎2017-05-10

Thanks Sergey , will try your suggestion