topic Change the field data in QlikView

Change the field data

Sat, 24 Dec 2011 11:12:16 GMT

Hi all,

In current field "A" having the data like

Defect.Edgechip

Defect.ExcessPiece.Poly

Defect.Excess.Flah

System.Others

Lens.Missing.

Now can i get the field "A" values like

EdgeChip

ExcessPiece.Poly

Excess.Flash

Others

Missing

what calculated expression should i use to work on it ?

Thanks in advance.

Regards

Venkat

Change the field data

Miguel_Angel_Baeyens — Sat, 24 Dec 2011 11:14:39 GMT

Hi Venkat,

Use something like the following:

SubField(A, '.', 2) AS A

Hope that helps.

Miguel

Re: Change the field data

Sat, 24 Dec 2011 11:40:35 GMT

Hi Miguel,

For below two values

Defect.ExecePiece.Flash,

Defect.ExecePiece.Poly

it is showing the result for both values like ExecePiece,

but it should have like

ExecePiece.Flash ,

ExecePiece.Poly.

Regards

Venkat

Re: Change the field data

Miguel_Angel_Baeyens — Sat, 24 Dec 2011 11:57:15 GMT

Venkat,

Use this instead:

=Mid('Defect.ExcessPiece.Poly', Index('Defect.ExcessPiece.Poly', '.') +1)

Regards.

Miguel

Re: Change the field data

Sat, 24 Dec 2011 12:19:41 GMT

Hi Miguel,

Its working fine.

And one more doubt in attached application, the axes of the barchart should change according the bars displayed in chart for each DefectNameShort.

i.e; if the max barchart count is 315, then the StaticMax Axes should be 315, and

if the min barchart count is 10, then the StaticMax Axes should be 0

what expression should i provide for the axes ?

Regards

Venkat

Re: Change the field data

Miguel_Angel_Baeyens — Sat, 24 Dec 2011 12:31:41 GMT

Hi Venkat,

This is a quite different question (string handling, static axes chart...), so can you please place in a different thread with that elaborating on the document you attach what you expect and what selections to make? You can always use in the Static Min or Max the Min() and Max() as well as any other aggregation expression.

Regards,

Miguel