Discussion Board for collaboration related to QlikView App Development.
I have two data island tables in my data model. In that tables i have a 'ID' field in Table1 and 'Number' field in the Table2. Both are different. some of the data are matching. I have given a trigger for auto selection of these two values.
For Example if i select ID value as 1 then it will selects the Number value 1 in Table2. This is working fine for me. But if i select the ID as 5 that value is not there in the Number Field i.e. Table2. On that case the all the data is showing in Table2. But as per the requirement, in that case i need to show only the Empty report instead of showing all the data in table2 ( only headers as report).
Can any one please help on this.
I tried to workout the same. As per the Requirement, If no matching field is available then we need to show the report with headers. But in this case the entire report will goes to hide and By Default we want to shows all the data
Attached the Sample application. In that if you select ID values from 1 to 5, In 1st table and 2 nd table you will get the values according to the selection. But If you select 11, 12 then in table2 we are getting all the data. I dont want to see all the data, Just null data with the hearders in that case.
Please help me.
Thanks for reply. I want it dynamically. for example if the user selects one ID, we need to show the same in Table2. Sometimes, they will select multiple.That time also we need to show as per their selection. By default we need to show all the data. So, this will not satisfy the requirement. can you please suggest me any other method.