topic Re: How to show path on the sheet in QlikView

How to show path on the sheet

ferha_jafri — Thu, 27 Jun 2013 05:26:05 GMT

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

ariel_klien — Thu, 27 Jun 2013 07:52:01 GMT

Try GetActiveSheetId()

Ariel

israrkhan — Thu, 27 Jun 2013 08:03:08 GMT

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.

you can try GetFolderPath() as well...

Hope it helps.

ferha_jafri — Fri, 28 Jun 2013 05:49:27 GMT

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 — Sat, 29 Jun 2013 08:34:15 GMT

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 — Sat, 29 Jun 2013 10:45:44 GMT

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

ferha_jafri — Mon, 01 Jul 2013 04:39:21 GMT

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 — Mon, 01 Jul 2013 06:53:22 GMT

Hello All,

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