topic Max length of all fields in the Dashboard in QlikView

Max length of all fields in the Dashboard

raajaswin — Tue, 23 Jun 2020 13:55:18 GMT

Hi All,

I have a requirement to display the list of all the field names and its maximum value length.

I have tried max(len($Field)) in front end which gives me length of the field name not the value.

I have tried loops in script tried max(len(FieldName(Field,Table)) , again it gave length of the field name not the value..

Please suggest a solution.. Front end or in script any thing is fine

My desired o/p is

Table NAme	Field Name	Maxlength
Table1	Field1	22
Table1	Field2	10
Table2	Field1	121
Table2	Field2	23
Table2	Field3	34
Table3	Field1	20

Re: Max length of all fields in the Dashboard

yogi_myd — Tue, 23 Jun 2020 14:07:27 GMT

hi,

Find the Max length of the fields in each table while load itself and sort by Descending order.

Do the Resident load where rowno=1 and concatenate as single table and present in the dashboard.

Regards

Yogesh.

Re: Max length of all fields in the Dashboard

Taoufiq_Zarra — Tue, 23 Jun 2020 15:05:44 GMT

Hi,

one solution on load Script :

Suppose I have those Tables :

The Script :

Table1: load * inline [ A,B,C 1,2564,56464 dfgs 10,25,56464 dfgssd ]; Table2: load * inline [ AA,BB,CC 1sdfd,25sdfs64,56fdsfds464 dfgs 1fsdf,2ff5,56dfsdffsdfsdfd464 dfgssd ]; FOR i = NoOfTables()-1 to 0 STEP -1 LET vTable=TableName($(i)); FOR j =1 to NoOfFields('$(vTable)') FieldMax: let vFieldName=FieldName($(j),'$(vTable)') ; //let vfakue=Peek($(vname),'$(vTable)'); LOAD len($(vFieldName)) as lengthfield, '$(vTable)' as [Table Name], '$(vFieldName)' as [Field Name] RESIDENT [$(vTable)]; NEXT j NEXT i outputFieldMax: noconcatenate load [Table Name],[Field Name], max(lengthfield) as Maxlength resident FieldMax group by [Table Name],[Field Name] ; drop table FieldMax;

The output :

Re: Max length of all fields in the Dashboard

raajaswin — Wed, 24 Jun 2020 06:05:34 GMT

Yes This is working. Thanks..

But it loads all the columns again.. like if there are 200 columns in the dashboard. It loads all the columns again.. I am using this solution as of now. But please let me know if something can be done in a optimized way either in front end or scripting

Re: Max length of all fields in the Dashboard

Taoufiq_Zarra — Wed, 24 Jun 2020 08:47:18 GMT

yes!

Table1: load * inline [ A,B,C 1,2564,56464 dfgs 10,25,56464 dfgssd ]; Table2: load * inline [ AA,BB,CC 1sdfd,25sdfs64,56fdsfds464 dfgs 1fsdf,2ff5,56dfsdffsdfsdfd464 dfgssd ]; FOR i = NoOfTables()-1 to 0 STEP -1 LET vTable=TableName($(i)); FOR j =1 to NoOfFields('$(vTable)') FieldMax: let vFieldName=FieldName($(j),'$(vTable)') ; //let vfakue=Peek($(vname),'$(vTable)'); LOAD Max(len($(vFieldName))) as lengthfield, '$(vTable)' as [Table Name], '$(vFieldName)' as [Field Name] RESIDENT [$(vTable)]; NEXT j NEXT i

Re: Max length of all fields in the Dashboard

tresB — Wed, 24 Jun 2020 09:08:56 GMT

A UI solution would be a tricky one but possible.

$(=concat('if($Field=' & chr(39) & $Field & chr(39) & ',Max({1}Len([' & $Field & ']))', ',') & concat(right($Field&')',1)))

Credit goes to @rbecher