Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Create Nulls If Related data doesn't exist.

i have a table containing 3 fields. i.e . dates ,items, quantity.  i want that if i select a particular date for eg... 20/sept/2012. then ,, in table box i need that all the possibles values that culd have been for that date.. for eg.. if items field contained 3 items a,b,c.. and suppose in above mentioned date a item was cosumed.. then when i select that date i will get only a data in normal condition . but i want that when i select that date i get a, as well as b and c also but in place of b and c i will have null as quantity. and for a i will have actual quantity involved... please help me.. here is that excel file i have...

Thank you in advance.

10 Replies
Not applicable
Author

Sorry.. but it didnt work.