topic Re: logic in QlikView

logic

smilingjohn — Wed, 25 Nov 2020 16:16:04 GMT

Hi All, Can someone tell me what the below scripting doing ?

Period: LOAD date(fieldvalue('Period1',recno()),'MMM-YYYY') as Period AUTOGENERATE fieldvaluecount('Period1');

here there is no path from.... l but still this is executing . i wonder how ? Can please someone explain me this ?

Thanks in advance

Re: logic

Gysbert_Wassenaar — Mon, 07 Aug 2017 09:34:20 GMT

It creates a table called Period with only one field that's also called Period. It is using the values in a field called Period1 to create the values for the Period field. Look in the online help qlik.com/help to see what the functions fieldvalue, fieldvaluecount and autogenerate do. I can explain, but the online help already does and you'll learn more if you try to find answers yourself.

Re: logic

rahulpawarb — Mon, 07 Aug 2017 09:34:20 GMT

In the provided script, you are loading a Period table a period field (Format: MMM-YYYY) using the Autogenerate clause.

fieldvaluecount('Period1') will returns the number of distinct value available for Period1 field and then this result is fed to AUTOGENERATE clause.

Field date(fieldvalue('Period1',recno()),'MMM-YYYY') as Period will return Field value of Period1 for respective row nos.