topic Re: Triggers Issue in QlikView

Triggers Issue

bharatkishore — Mon, 06 Mar 2017 15:27:26 GMT

Hi All,

I am facing an issue which i am not sure where it is happening.

Firstly i have an listbox Attached image for reference:

I don't know why training compliance is not getting selected default.

When i select manually then data is coming, but i want know why this is happening.

Can you please help me.

Thanks,

Bharat

awhitfield — Mon, 06 Mar 2017 15:35:31 GMT

Hi Bharat,

as the value is 'Greyed' out that means it's excluded by some selection, can you upload a sample .qvw we can investigate?

Andy

bharatkishore — Mon, 06 Mar 2017 16:27:25 GMT

Thanks Andrew for your quick response.

Attached qvw for reference.

Please un-select Training Compliance then you can see the data. I don't kno

Thanks,

Bharat

jcs_2015 — Mon, 06 Mar 2017 20:06:36 GMT

@Bharat,

None of your tables are associated to the other. At a minimum, they should likely connect via a standardized Time dimension, i.e. Master Calendar.

Fact_Cube_Date houses the DIM MonthYear

Fact_CSPDSC_Data houses the DIMs Numerator and Denominator.

MonthYear was defaulted to 12/1/2016