topic Re: Bug Qlik sense 3.1 SR2 in filter when using aggr() in App Development

Bug Qlik sense 3.1 SR2 in filter when using aggr()

Wed, 07 Dec 2016 09:53:47 GMT

Hi all,

I just found a new bug in the 3.1 SR2 version. (at least I think it is a bug)

If i use the "compact" version of a filter nothing appear.

Eg :

if a create a filter containing a date : the data just being "=feedback_created_at"

if works, but if i change the formula to : "aggr(feedback_created_at,feedback_created_at)" I got :

I need to add a wildcard in the research field to see my data :

So far I didn't found any workaround for this, ideas anyone ?

Re: Bug Qlik sense 3.1 SR2 in filter when using aggr()

Gysbert_Wassenaar — Wed, 07 Dec 2016 10:02:02 GMT

Why would you even want to use aggr( Field, Field) as expression for a filter pane?

For what it's worth, this behavior is the same in Qlikview and I doubt it has ever been different.

Re: Bug Qlik sense 3.1 SR2 in filter when using aggr()

Thu, 08 Dec 2016 02:14:58 GMT

gwassenaar‌

This is for the example of the bug, any aggr would produce this.

I didn't have this probleme on Qlik sense 3 or 3.1, it only started on Qlik Sense 3.1SR2

Re: Bug Qlik sense 3.1 SR2 in filter when using aggr()

Gysbert_Wassenaar — Thu, 08 Dec 2016 06:15:51 GMT

I'm probably misunderstanding you. Anyway, if you think you've discovered a bug then open an issue with Qlik Support.

Re: Bug Qlik sense 3.1 SR2 in filter when using aggr()

Fri, 09 Dec 2016 11:45:01 GMT

i have the same problem and i don't used aggr() function but a simply IF()

but Just beside it I have another filter and it works with the same type of function

Re: Bug Qlik sense 3.1 SR2 in filter when using aggr()

Tue, 13 Dec 2016 08:16:45 GMT

Hi,

Double check that you have data in your service line when it is not compacted, or that you have data when you put the wildcard.

I tried to raise an issue but I couldn't access the qlik bug reporting platform with my account.

Re: Bug Qlik sense 3.1 SR2 in filter when using aggr()

shraddha_g — Tue, 13 Dec 2016 08:19:47 GMT

Try

if(wildmatch([Entity Name],'sample1','sample2'),[Service Line])

Re: Bug Qlik sense 3.1 SR2 in filter when using aggr()

Tue, 13 Dec 2016 08:45:30 GMT

Hello,

Yes I have data when i put a wildcard.

Thanks

Re: Bug Qlik sense 3.1 SR2 in filter when using aggr()

Tue, 13 Dec 2016 08:49:19 GMT

Hello,

thanks for your suggested , but it doesn't work.

I had open a case on support Qlik

Re: Bug Qlik sense 3.1 SR2 in filter when using aggr()

Thu, 15 Dec 2016 09:38:38 GMT

Bug ID open on Qlik Tech Support : QLIK-71054

Re: Bug Qlik sense 3.1 SR2 in filter when using aggr()

Fri, 16 Dec 2016 03:13:59 GMT

Thx douchetxavier‌

Re: Bug Qlik sense 3.1 SR2 in filter when using aggr()

amanjain57 — Fri, 17 Feb 2017 15:12:12 GMT

Hi douchetxavier‌ , do you know if this is fixed yet ??

I am facing the same issue.

Re: Bug Qlik sense 3.1 SR2 in filter when using aggr()

amanjain57 — Fri, 17 Feb 2017 15:12:55 GMT

hi clement.bitton‌

Do you know if this bug is fixed yet ??

I am facing the same issue.

Re: Bug Qlik sense 3.1 SR2 in filter when using aggr()

Mon, 20 Feb 2017 07:40:15 GMT

amanjain57‌

Apparently this issue have been fixed in Qlik 3.1 SR5. See here .

I havn't test it yet, will update this thread once tested

Re: Bug Qlik sense 3.1 SR2 in filter when using aggr()

Mon, 20 Feb 2017 09:38:03 GMT

So I tested the problem in SR5 and It doesn't appear anymore.

Will mark this as closed.