Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
Thanks,Same thing i want to search if you got let me know about that.
Regards
Anand
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
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
Hi,
No i dont know any other way to implement it from front end.
Regards,
Kaushik Solanki
There's a Find feature in Settings > Expression Overview that you can use for this.
open qlikview file-> settings(menu)-> expression overview ->export to excel-> control+f
and find your field.
hope this make sense
in qliksense how to find?