Qlick Sense redirection to another table

[fredziah11]

Hi

I have table with some details related with Production Orders which is displaying few columns ,and I have another table which also contains the Production Orders but contains other different data which are displayed.

Both data are in one main table - connected by LeftJOIN

I would like to have possibility that each Production Order in first table would be a link to second table if the same Production Order exist and after mouse click I would be redirected to this second table. Is that possible without using Pivot Table???

Or if not how it can be done with PivotTable so in first view I will have different columns than in this drilled down view?

Thanks in advance for any solution.

[Stoyan_Terziev]

Hello Fred,

If you want to redirect to another sheet where the other table is positioned, I think you need to use the 'URL' functionality in a straight table.

Once clicked it should redirect you to the URL without applying the selection though if I remember correctly.

So you probably want to separate the Order # itself and the URL in separate columns.

Let me know if that helps.

Kind regards,

S.T.