Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
ferha_jafri
Partner - Creator III
Partner - Creator III

How to show path on the sheet

Hello all ,

I want to show the path as Home > Group > Parameters > P&L

and Home > Group > Parameters > BS in this parameter is a button and P&L AND BS are the sheets.

Thanks in advance

Ferha Jafri

7 Replies
ariel_klien
Specialist
Specialist

Hi

Try GetActiveSheetId()

BR

Ariel

israrkhan
Specialist II
Specialist II

Hi,

Use filepath() function...

Example:

Load *, filepath( ) as X from

C:\UserFiles\abc.txt

Will return 'C:\UserFiles\abc.txt' in field X in each record read.  then you can concatenate sheetid or sheet name with.

OR

you can try GetFolderPath() as well...

Hope it helps.

ferha_jafri
Partner - Creator III
Partner - Creator III
Author

sorry but i am not able to use this function as i am not able to find this function in help as well,plz suggest what should i do.

ferha_jafri
Partner - Creator III
Partner - Creator III
Author

Please suggest me what should i do on this as i want to show the path as the path show the sheet name as we move from one sheet to other.

plz check the qvw,in this i want to show the path at the top of each sheet as we move from one sheet to other as:Home > Group > Parameters > P&L

kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

     Purdon me, I couldnt able to understand what you actually want to do.

     Kindly explain with example.

     If possible upload the same qvw file for reference.

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
ferha_jafri
Partner - Creator III
Partner - Creator III
Author

Hello Kaushik,

I attached my document ,i hope you got my issue plz if you the answer then let me know as i am not able to get the answer to the question.

Thank you

Ferha Jafri

ferha_jafri
Partner - Creator III
Partner - Creator III
Author

Hello All,

Please reply if anyone know how to show the path..