Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
krishna_venkata
Contributor II
Contributor II

Calculated dimension based on first field

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

1 Solution

Accepted Solutions
Sergey_Shuklin
Specialist
Specialist

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

2 Replies
Sergey_Shuklin
Specialist
Specialist

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

krishna_venkata
Contributor II
Contributor II
Author

Thanks Sergey , will try your suggestion