topic Re: Rank Dates in a Bar chart in QlikView

Rank Dates in a Bar chart

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

Hello,

I am trying to understand how to use the rank function.

I am reporting on license consumption. I have license keys that are valid for a certain length of time. I am looking to rank the create date as more important than the delete date.

My current issue is that I am trying to show consumption over time. But with a line graph there is a peek that is not valid for the counts when a new license is created in the same month that license expires.

My end goal is to not show the license count in the month if its the month it expired.

I would appreciate any help as I am new to this community.

Thank you,

Cassadi

Re: Rank Dates in a Bar chart

sasiparupudi1 — Fri, 27 Apr 2018 05:36:10 GMT

Please attach a sample

Re: Rank Dates in a Bar chart

Anonymous — Fri, 27 Apr 2018 18:46:03 GMT

Hi,

Maybe, you can put a flag in the expiration date for those licenses and use that flag in the set analysos to not count them.

Or make a condition comparing if( Expiration Date <> MonthYear, count (license) )

Regards,