Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
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