topic Re: Issuing on Triggers in QlikView

Issuing on Triggers

ashok1203 — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I have two data island tables in my data model. In that tables i have a 'ID' field in Table1 and 'Number' field in the Table2. Both are different. some of the data are matching. I have given a trigger for auto selection of these two values.

For Example if i select ID value as 1 then it will selects the Number value 1 in Table2. This is working fine for me. But if i select the ID as 5 that value is not there in the Number Field i.e. Table2. On that case the all the data is showing in Table2. But as per the requirement, in that case i need to show only the Empty report instead of showing all the data in table2 ( only headers as report).

Can any one please help on this.

Re: Issuing on Triggers

lironbaram — Wed, 07 Dec 2016 08:01:21 GMT

add to the report/table

a calculation condition the says

getselectedcount(NumberField)>0

that way only if you selected values the expressions in the table will be calculated

Re: Issuing on Triggers

ashok1203 — Wed, 07 Dec 2016 09:04:26 GMT

Hi,

I tried to workout the same. As per the Requirement, If no matching field is available then we need to show the report with headers. But in this case the entire report will goes to hide and By Default we want to shows all the data

Re: Issuing on Triggers

ashok1203 — Wed, 07 Dec 2016 09:52:17 GMT

Can anyone help me on this.

Re: Issuing on Triggers

sunny_talwar — Wed, 07 Dec 2016 09:55:27 GMT

Would you be able to share a sample of what you have?

Re: Issuing on Triggers

ashok1203 — Wed, 07 Dec 2016 09:58:16 GMT

It is difficult to share the application. For your reference i will create one sample application and share across the same.

Re: Issuing on Triggers

sunny_talwar — Wed, 07 Dec 2016 10:01:30 GMT

Ya that's what I am looking for. Thanks!!

Re: Issuing on Triggers

ashok1203 — Wed, 07 Dec 2016 11:01:23 GMT

Hi Sunny,

Attached the Sample application. In that if you select ID values from 1 to 5, In 1st table and 2 nd table you will get the values according to the selection. But If you select 11, 12 then in table2 we are getting all the data. I dont want to see all the data, Just null data with the hearders in that case.

Please help me.

Re: Issuing on Triggers

sunny_talwar — Wed, 07 Dec 2016 11:16:00 GMT

Can you see if the without trigger option works for you?

Re: Issuing on Triggers

ashok1203 — Wed, 07 Dec 2016 11:58:12 GMT

Hi,

Thanks for reply. I want it dynamically. for example if the user selects one ID, we need to show the same in Table2. Sometimes, they will select multiple.That time also we need to show as per their selection. By default we need to show all the data. So, this will not satisfy the requirement. can you please suggest me any other method.

Re: Issuing on Triggers

sunny_talwar — Wed, 07 Dec 2016 12:05:09 GMT

Slight Change in the expression:

If(GetSelectedCount(ID) > 0, Avg({<Number = P(ID)>} 2), 2)

No selection

With Selection Part 1

With Selection Part 2

With Selection Part 3

Is this what you want?

Re: Issuing on Triggers

ashok1203 — Wed, 07 Dec 2016 12:21:30 GMT

Thanks Sunny. Almost we have reached except one small thing. If the user selects 11 or 12, In Table 2 we need to show one empty row along with headers.

Re: Issuing on Triggers

sunny_talwar — Wed, 07 Dec 2016 12:29:57 GMT

To do that you will need to add another row which is blank to your second table in the script.

Re: Issuing on Triggers

ashok1203 — Wed, 07 Dec 2016 12:36:30 GMT

I have added the same, but i am not getting the desired result.

Re: Issuing on Triggers

sunny_talwar — Wed, 07 Dec 2016 12:38:53 GMT

Would you be able to share an updated sample with me? I will need to make some modifications to the expression

Re: Issuing on Triggers

ashok1203 — Wed, 07 Dec 2016 12:48:24 GMT

Hi,

Please find the sample attached, do the needful

Re: Issuing on Triggers

sunny_talwar — Wed, 07 Dec 2016 12:59:31 GMT

Check this out:

If(GetSelectedCount(ID) > 0,

If(Count(TOTAL Aggr(Sum({<Number = P(ID)>} 2), Number)) > 0, Sum({<Number = P(ID)>} 2), Sum({<Number = P(ID)+{'-'}>} 2)), 2)

Re: Issuing on Triggers

ashok1203 — Wed, 07 Dec 2016 13:09:04 GMT

Hi Sunny, It's working Fine for me as per requirement. Is their any possibility to show the null record with out creating it in the source. I am reading Original data from Oracle Queries that does not contain any Null records.I don't have any scope to create it in the source.

Re: Issuing on Triggers

sunny_talwar — Wed, 07 Dec 2016 13:27:54 GMT

Concatenate the null row through an inline load.

Re: Issuing on Triggers

ashok1203 — Wed, 07 Dec 2016 13:33:09 GMT

Thanks Sunny For your Quick Help.