How to break the link(Movement of sheets from selection)

[qlik4asif]

Hi Team,

I have a requirement

My Dashboard comprise of Pivot table with Dimensions as KPI, Region,.... and Column as YTD, Target, Status

Now my requirement is when i select any KPI from KPI column it need to take to particular KPI sheet(Each KPI has Separate sheet with Brief data)

I have used text box, with triggers( activate sheet) by increasing transparency and placed over each KPI.

But the problem with this is My pivot table is large with scroll bar, so when i scroll it, the other kpi may come over the text box, when i select the kpi then it takes me to particular sheet of text box which is not correct.

Then i have used Field based triggers(Doc Properties) with Trigger activate sheet and expression--------Pick(Wildmatch(KPI,'KPi1','KPI2'.....),'SH01','SH02'......)

This is working fine , but the problem is even when i select KPI in list box it is navigating to sheets

I want movement to sheets only in Pivot table KPI selection but not any where.

Alternative state is a solution but it will be a complex for me.

So please throw some light on this issue

Thanks in advance

Asif

[swuehl · Accepted solution]

Maybe it's enough to duplicate the KPI field in your script.

Then you can use one field as dimension in your table and one for the list box.

You should be able to set up the field based triggers to only trigger when there is an active selection in that field.

Should be easier than using alternate states.

[qlik4asif]

In that case if i try to filter the pivot according to KPI( list box) , it wont filter right,

becoz in Pivot table we are using different field(Duplicate)

[swuehl]

Hm, it should filter right, because it's a straight duplicate field in the same table.

edit: sample attached

[qlik4asif]

Can you attach any sample application

[swuehl]

Yes I can and I did in my previous post (you can't see attachments from the Inbox, you need to open the thread).