topic Re: Load data based on certain conditions in QV script in QlikView

Load data based on certain conditions in QV script

vireshkolagimat — Wed, 28 Sep 2016 11:13:53 GMT

Hi,

I have some data in the below format. I want to load data only on specific day.

For example, if it is friday, i don't want to load the data but if it is monday i need to load the same data.

In chart i am able to achieve this using variable and weekday function. But this will not fullfil my requirement.

Can we do a similar thing in QV script while loading data.

Regards,

Viresh

In the below case, i want to load only header1 one information on Friday and Header1 & Header2 information on Monday

Header 1	Header 2
Comments1	Comments3
Comments2	Comments4

Re: Load data based on certain conditions in QV script

sunny_talwar — Wed, 28 Sep 2016 11:18:12 GMT

So you don't want to reload the whole applicatipn on Monday? or you don't want to load a specific table on Monday? If it is for a specific table, you might be able to do this

If WeekDay(Today()) <> 'Mon' then

TableName:

LOAD [Header 1],

[Header 2],

....

FROM ....

ENDIF;

Re: Load data based on certain conditions in QV script

vireshkolagimat — Tue, 18 Oct 2016 12:07:56 GMT

Hi, it works fine but it will leave a hypen '-', if the object is not found in the nprinting template. Any idea how can we avoide this '-' in the template.

thanks

Re: Load data based on certain conditions in QV script

sunny_talwar — Tue, 18 Oct 2016 12:16:56 GMT

I have very limited expertise in nPrinting, so won't be able to offer much on that front.

Re: Load data based on certain conditions in QV script

vireshkolagimat — Tue, 18 Oct 2016 14:31:40 GMT

Hi, Can we create the objects based on the script or using macro. My requirement is if there is no data to show in a particular object, then i don't want that object(for ex table box) in the qvw file and it should be populated if there is a data show in that object.

I really don't know if that can be possible but just curious to know.

thank for your support.

Regards,

Viresh

Re: Load data based on certain conditions in QV script

wallerjc — Tue, 18 Oct 2016 15:14:55 GMT

Viresh

this can be done in the 'Layout' tab under Conditional show condition.

Can you create a 'fake field', in your script e.g. "DateToday" then base your show condition based on this variable?

Re: Load data based on certain conditions in QV script

vireshkolagimat — Wed, 19 Oct 2016 12:01:29 GMT

Hi, thanks for the suggestion.

I am using the below script in Layout tab -> conditional show

if(weekday(today())<>'Wed',1,0)

but the object is still showing in qvw file. Did i missed something.