topic How to find whether the fields has been used in the charts! in QlikView

How to find whether the fields has been used in the charts!

Wed, 14 Sep 2011 05:06:34 GMT

Hi All

How to find whether the field which is there load script is been used in any of the charts or not(In dimension/expression/variable). I don't want to open one by one chart and see are we using the particular field as it is time consuming job.

Can some one please help me out with the best way to investigate whether we are using that field or not.

Thanks

Attitude

How to find whether the fields has been used in the charts!

its_anandrjs — Wed, 14 Sep 2011 05:14:00 GMT

Hi,

Thanks,Same thing i want to search if you got let me know about that.

Regards

Anand

How to find whether the fields has been used in the charts!

kaushiknsolanki — Wed, 14 Sep 2011 05:52:21 GMT

HI,

Try this.

tmpSOE:

LOAD

filepath() as FileName,

SheetId as ObjectId,

'Sheet' as SOE_Type,

Title as Label

FROM C:\pqr.qvw (XmlSimple, Table is [DocumentSummary/Sheet]);

// Sheet Objects

OUTER JOIN LOAD

filepath() as FileName,

REPLACE(ObjectId,'Document\','') as ObjectId,

Type as SOE_Type,

Caption as Label

FROM C:\pqr.qvw (XmlSimple, Table is [DocumentSummary/SheetObject]);

//Expressions:

OUTER JOIN LOAD

filepath() as FileName,

ObjectId,

'Expression' as SOE_Type,

Definition,

Label

FROM C:\pqr.qvw (XmlSimple, Table is [DocumentSummary/Expression]);

//CalculatedDimension:

OUTER JOIN LOAD

filepath() as FileName,

ObjectId,

'Dimension' as SOE_Type,

PseudoDef as Definition,

Title as Label

FROM C:\pqr.qvw (XmlSimple, Table is [DocumentSummary/Dimension]);

//VariableDescription:

OUTER JOIN LOAD

filepath() as FileName,

ObjectId,

'Variable' as SOE_Type,

RawValue as Definition,

Name as Label

FROM C:\pqr.qvw (XmlSimple, Table is [DocumentSummary/VariableDescription]);

//Report:

OUTER JOIN LOAD

filepath() as FileName,

Id as ObjectId,

'Report' as SOE_Type,

Name as Label

FROM C:\pqr.qvw (XmlSimple, Table is [DocumentSummary/Report])

WHERE Id > '';

//BookmarkItems:

OUTER JOIN LOAD

filepath() as FileName,

BookmarkId as ObjectId,

'Bookmark Item' as SOE_Type,

BookmarkField as Label

FROM C:\pqr.qvw (XmlSimple, Table is [DocumentSummary/BookmarkItems]);

//Bookmark:

OUTER JOIN LOAD

filepath() as FileName,

BookmarkId as ObjectId,

'Bookmark' as SOE_Type,

Name as Label

FROM C:\pqr.qvw (XmlSimple, Table is [DocumentSummary/Bookmark]);

Hope this will solve many of your problems.

Regards,

Kaushik Solanki

How to find whether the fields has been used in the charts!

Tue, 27 Sep 2011 05:48:33 GMT

Hi Koushik

Thanks for your effort. Unfortunately I didn't get much to look into it.

By the way I also wants to find out whether the variable which has been created in the script has been used in the GUI or not. It will help me to remove the unwanted variable which is there in the script. Doing this script will be clear and readable :-).

I can see that with the help of above script we can find whether the variable has been used or not. But is there is any way to find without using above script. I mean in the front end!

Thanks

Attitude

How to find whether the fields has been used in the charts!

kaushiknsolanki — Tue, 27 Sep 2011 06:30:13 GMT

Hi,

No i dont know any other way to implement it from front end.

Regards,

Kaushik Solanki

How to find whether the fields has been used in the charts!

gussfish — Tue, 27 Sep 2011 07:56:02 GMT

There's a Find feature in Settings > Expression Overview that you can use for this.

How to find whether the fields has been used in the charts!

Anonymous — Tue, 27 Sep 2011 08:02:10 GMT

Maybe this can be of some assistance?

http://community.qlik.com/message/150512#150512

Dennis.

How to find whether the fields has been used in the charts!

SunilChauhan — Tue, 27 Sep 2011 10:07:55 GMT

open qlikview file-> settings(menu)-> expression overview ->export to excel-> control+f

and find your field.

hope this make sense

Re: How to find whether the fields has been used in the charts!

sbkumar — Wed, 04 Jul 2018 07:22:16 GMT

in qliksense how to find?