topic Re: Remove dimension result if no expression data for a period in QlikView

Remove dimension result if no expression data for a period

Mootilate — Sat, 16 Nov 2024 19:16:48 GMT

I am looking to remove results from a dimension where there has been no results for a set period of time.

As you can see from the image, James has had no scores for more than 6 weeks so should not show in the table anymore as he will have left the company.

Thanks for any help.

Re: Remove dimension result if no expression data for a period

Taoufiq_Zarra — Sat, 18 Jan 2020 13:55:39 GMT

several options
but if you want to display only Names with a number higher than 6 of date for example

you can replace Dimension Name by :

=aggr(only({<Name={"=count(date)>6"}>} Name) ,Name)

and Supress when value is Null

Re: Remove dimension result if no expression data for a period

Mootilate — Sun, 19 Jan 2020 03:54:37 GMT

Thanks, that answers some of the question, but I am looking for where there is nothing in the previous 6 weeks.

That just checked if there was more than 6 weeks worth of data. My data set goes back years.

Re: Remove dimension result if no expression data for a period

Taoufiq_Zarra — Sun, 19 Jan 2020 11:45:20 GMT

yes, its also possible

can you share a sample data i can send you the script

Re: Remove dimension result if no expression data for a period

Mootilate — Mon, 20 Jan 2020 11:20:29 GMT

Hi the table above has Names, Score and Date

Re: Remove dimension result if no expression data for a period

Anil_Babu_Samineni — Mon, 20 Jan 2020 12:28:25 GMT

Perhaps with inner analysis?

Sum({<Name-={"=Sum({<Week={">=$(=Max(Week-6))<=$(=Max(Week))"}>} Measure)=0"}>} Measure)

Re: Remove dimension result if no expression data for a period

Brett_Bleess — Thu, 13 Feb 2020 19:20:52 GMT

Did Anil's last post get you what you needed? If so, do not forget to return to the thread and use the Accept as Solution button on his post. This gives him credit for the help and lets other Community Members know what worked. We appreciate it if people do close out their threads rather than leaving them unsolved, so please either mark things or let us know what you still need. If you are still working upon things, as Taofiq referenced, you will get faster help if you can attach a sample app with the data model etc., as that makes it much easier for folks to figure out what the correct solution is.

You may also want to bookmark the following link, as there are over 700 posts there from our internal experts and most are how-to related, so that will likely be very helpful to you going forward too.

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

Regards,
Brett