Discussion Board for collaboration related to QlikView App Development.
HOW TO @write a condition in script to check whether data is avalable or not in table.QlikTech Admin
What do you mean by "Data is available or not". Kindly elaborate in detail.
You can use filter condition in load script using "Where" clause, something like:
Where Field1 = 'A'
And you can add more conditions per your requirement.
Hope this helps!
Tru NoOfRows(), please check example below
NoOfRows('TableName ' )
Returns the number of rows (records) in a previously loaded table.
If the function is used within a load statement, it must not reference the table currently being loaded.
LET vRowCount = NoOfRows('tab1');
Get the rows count in table tab1 and stores it in variable vRowCount and use this variable with IF THEN ELSE.
Hope this helps you.