Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

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

8 Replies
its_anandrjs

Hi,

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

Regards

Anand

kaushiknsolanki
Luminary Alumni
Luminary Alumni

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

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".
Not applicable
Author

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

kaushiknsolanki
Luminary Alumni
Luminary Alumni

Hi,

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

Regards,

Kaushik Solanki

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".
gussfish
Creator II
Creator II

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

dennisnet
Partner
Partner

Maybe this can be of some assistance?

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

Dennis.

TigerisBack
Champion
Champion

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

and find your field.

hope this make sense

sbkumar
Creator
Creator

in qliksense how to find?