Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
bharatkishore
Creator III
Creator III

Make data to null

HI All,

@sunny_talwar 

I have 2 tables and i have a derived contract flag and these columns from second table:

[Sales Document] as Sales.Document_Contract,
Item as Item_Contract,
Equipment,
Date(Start_DT_New,'MM/DD/YYYY') as Start_DT_New,
Date(End_DT_New,'MM/DD/YYYY') as End_DT_New,
MaterialEntered

Now i have written an expression to get contract flag i.e. 

if(Posting.Date>=Start_DT_New and Posting.Date<=End_DT_New,'Contract Period','Outside Contract Period' )as Contract_Flag

Now where ever the i get Outside Contract Period i want all the above mentioned columns to be null.

Can you please help me how to achieve it.

Thanks,

Bharat

Attaching qvw for reference.

Please let me know if you need anything more

13 Replies
anushree1
Specialist II
Specialist II

i see it working when Contract Flag ->Outside Contract Period Selected the Table is blank

else it shows the relevant records.

Please check the code starting from Noconcatenate in the attached file.

Please let me know if you were looking for some other output

anushree1
Specialist II
Specialist II

i see it working when Contract Flag ->Outside Contract Period Selected the Table is blank

else it shows the relevant records.

Please check the code starting from Noconcatenate in the attached file.

Please let me know if you were looking for some other output

bharatkishore
Creator III
Creator III
Author

Thank you Jamie.. Worked perfectly... But only problem is for few columns data is matching and few other equipments data is not matching
bharatkishore
Creator III
Creator III
Author

Thank you Anushree for your time.. Jamie code worked.. thanks once again..