topic Re: How to assign zero value in second refresh in QlikView

How to assign zero value in second refresh

gireesh1216 — Sat, 16 Nov 2024 00:53:19 GMT

Hello Team,

Below is the script.Qlikview app first refresh vSuccess should show 1 and second refresh vSuccess should show zero.

How to achieve this ?

Let vTest='A';

If vTest='A' then

Let vSuccess=1;

Else

Set vSuccess='False';

end if

Exit Script;

Output:

1.QlikView First Refresh vSuccess=1 (Return 1 value)

2..QlikView second Refresh vSuccess=0 (vSucess should show zero)

Thanks,

Gireesh

Re: How to assign zero value in second refresh

sunny_talwar — Tue, 07 Apr 2020 11:05:13 GMT

How about the third refresh? or the first refresh of the hour or day or month or year is set to 1 and then every subsequent ones are set to 0?

Re: How to assign zero value in second refresh

gireesh1216 — Tue, 07 Apr 2020 11:07:46 GMT

Need 1 only for first refresh and other subsequent refresh it should return 0.

Re: How to assign zero value in second refresh

sunny_talwar — Tue, 07 Apr 2020 11:10:41 GMT

1st refresh ever or 1st refresh of the day or 1st refresh of the month?

Re: How to assign zero value in second refresh

gireesh1216 — Tue, 07 Apr 2020 11:14:34 GMT

1st refresh of every month

Re: How to assign zero value in second refresh

sunny_talwar — Tue, 07 Apr 2020 11:16:15 GMT

Try this

If MonthStart(Today()) = If(Len(Trim(vLastReloadDate)) > 0, vLastReloadDate, 0) THEN LET vSuccess = 0; ELSE LET vSuccess = 1; ENDIF; TRACE $(vSuccess); LET vLastReloadDate = Num(MonthStart(Today(1)));

Re: How to assign zero value in second refresh

gireesh1216 — Tue, 07 Apr 2020 13:24:40 GMT

Below condition is failing at first time because of variable(vLastReloadDate) not found.

If MonthStart(Today()) = If(Len(Trim(vLastReloadDate)) > 0, vLastReloadDate, 0) THEN

Re: How to assign zero value in second refresh

sunny_talwar — Tue, 07 Apr 2020 13:28:30 GMT

To handle the no value within vLastReloadData, I am using Len(Trim())... I tried it before sending the code and it worked for me. Can you share a sample where this isn't working? or share screenshot where we can see that this doesn't work.

Re: How to assign zero value in second refresh

gireesh1216 — Tue, 07 Apr 2020 13:38:17 GMT

Its Working fine.Thank you so much 🙂

Re: How to assign zero value in second refresh

sunny_talwar — Tue, 07 Apr 2020 13:56:07 GMT

Awesome, I am glad it worked now. Please close the thread by marking a solution.

Best,
Sunny