topic Re: Trigger Issue in QlikView

Trigger Issue

ivandrago — Mon, 03 Nov 2014 17:37:00 GMT

Hi.

I have a Trigger issue within the Sheet Properties for the attached Document, if you click on each sheet the trigger will select the relevant Type as per the named sheet.

But if you click on "Archive" sheet and select Year = "2011" then go back to the Sheet "Sales" the Type field gets removed?

Which will cause confusion for the user as the sheet should be locked to type = "Sales"

Thanks

Re: Trigger Issue

stigchel — Mon, 03 Nov 2014 17:44:59 GMT

The selection on Type fails as there are no Sales for the year 2011 in your example. A solution could be to do a (unlock and) clear all before selecting the desired selections for each sheet

Edit (See attached example)

Re: Trigger Issue

simondachstr — Mon, 03 Nov 2014 17:45:48 GMT

Sheet = "Sales" does not have a corresponding Year = "2011" value. So what is happening is the following:

a) Everything gets locked (including Year = "2011")

b) Sheet gets unlocked and clear (Archive is deselected)

c) You are trying to select Sheet = "Sales" but it's excluded, because there is no Sales for Year = "2011", therefore your selection is NOT made.

d) You unlock everything

Re: Trigger Issue

MK_QSL — Mon, 03 Nov 2014 17:47:10 GMT

Yes because, In 2011 you don't have any Sale data.

If you select 2012 or 2013 from archive sheet and go to Sale, you will definitely get year and type field selected.

Re: Trigger Issue

JonnyPoole — Mon, 03 Nov 2014 18:10:20 GMT

The data doesn't have any rows where Type=Sale when Year=2011.

So when you activate the ''Sales' sheet and lock all the fields (with Year=2011) and then try to 'select in field' on 'Sale' it doesn't work because Year=2011 is locked and you can't have two filters that show opposite data. That is for better or worse how the associative model works.

I think you could resolve this by loading dummy 0 values as placeholders...so add this to the data for example:

Sale, 1, 0, 0, 0, 2011

...but that seems like a lot of work especially with lots of dimensions.

Consider using SET ANALYSIS (not available in table boxes) as a way of hard filtering anything on the chart to Type='Sale' or 'Archive' depending.