topic Re: Evalute which fields are being used by which values in QlikView

Evalute which fields are being used by which values

ni_avoss — Wed, 24 Aug 2016 10:49:47 GMT

Hi there,

for debug purposes I am trying to find a way to find all values which are in use for certain values, because I have a datamodel with a huge amount of fields.

The following example is probably more clear.

lets say this is the abstract structure:

Event	Field1	Field2	Field3	Field4
Event1	1	2
Event2			2
Event3		2		3
Event1				1

From this I would like to have a chart like this

Event	Fields in use
Event1	Field1
	Field2
	Field4
Event2	Field3
Event3	Field2
	Field4

I started and trying to build a calculated Dimension around $Field but so far I am not able to get this right. Is there another approach someone would like to share?

thanks a lot,

Alex

Re: Evalute which fields are being used by which values

agomes1971 — Wed, 24 Aug 2016 15:32:01 GMT

Hi,

have you checked this?

The Crosstable Load

HTH

André Gomes

Re: Evalute which fields are being used by which values

ni_avoss — Wed, 24 Aug 2016 15:40:59 GMT

Hi there,

no - not yet I wasn't aware of this function which looks really useful to me.

However for my usecase it might be only a last possible option as I there is really a big amount of columns and those are also dynamic and changing,(each column is basically a JSON-property) so I would need to adjust the script when reloaded the data which I would prefer not to do. Also, I would like to do the analysis in chart and not via datamodel

anyway - thanks,

alex

Re: Evalute which fields are being used by which values

vishsaggi — Wed, 24 Aug 2016 15:56:04 GMT

Try this provided if you have that data in any excel file just give that excel path.

CrossTable(Fields, Value)

LOAD Event,

Field1,

Field2,

Field3,

Field4

FROM

[..\Desktop\EgFile_2.xlsx]

(ooxml, embedded labels, table is Sheet1);

Create a straight table chart and use

Dim: Event, Fields

Expr: Value

Thanks,
V.