topic Re: aggr() in QlikView

aggr()

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

Hi Experts,

Can any one please help me on below requirement.

I have tow fields something like below. From these two fields I have to extract Number of Days as separate field like

Number of Days

In the UI i have crated Number of days field with this expression getting correctly but i need to create in back end.

= Aggr(Only({<name = {'Number of Days'}>} Value), Value)

Can any one please help me how to create this field in the back end. Please find the attached app.

Thanks in advance.

sunny_talwar — Thu, 15 Mar 2018 12:22:49 GMT

Check the attached

bhavvibudagam — Thu, 15 Mar 2018 12:57:52 GMT

Hi Sunny,

Thanks for your reply. The logic is working fine.

But i am not getting how to apply this in my data model. Could you please help me on this.

My data model contains Two tables. These two tables were linked with Issue id.

name and value fields are coming from Table 2.

Table1: (created with multiple joins)

Load

Issue id

priority

class

Testing

From ...

Table2:(created with multiple joins)

Load

Issue id

name

Value

customfield

createdate

end date

from...

Thanks in advance.