Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a pivot table which has multiple levels of data like Country,state,region and block.The sum of sales is calculated for these columns and the aggregated value has a hyperlink in the expression. When i click on it it opens into a new web page but its has to pass a unique ID for each sales value corresponded to its region.
for example in each region, each block has a unique ID but it seems as i added a hyperlink if i use GetFieldSelections or Only function it is returning a NULL value.It seems the Hyperlink is acting as a layer and i am not able to get the ID. Is there any way around i could get the ID?
Thanks In advance....
I didn't understand ID? What does is act as on URL / Hyper link?
Can you elaborate more
Check if this blog post what you are looking for: QlikView Mashups - Simple Document Integration