Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
Not applicable

write a condition in script to check whether data is avalable or not in table.

hi,

HOW TO @write a condition in script to check whether data is avalable or not in table.QlikTech Admin

3 Replies

Re: write a condition in script to check whether data is avalable or not in table.

Hi,

     What do you mean by "Data is available or not". Kindly elaborate in detail.

Regards,

Kaushik Solanki

Not applicable

Re: write a condition in script to check whether data is avalable or not in table.

Hi,

You can use filter condition in load script using "Where" clause, something like:

Temp:

Load
Field1,

Field2,

Field3

........

Where Field1 = 'A'

And you can add more conditions per your requirement.

Hope this helps!

MVP & Luminary
MVP & Luminary

Re: write a condition in script to check whether data is avalable or not in table.

Hi Pankaj,


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.

Examples:

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.

Regards,

Jagan.