Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
ryansolamen
New Contributor III

Automatic deletion of named CAL's

Hello,

In a scheduled manner i used to delete unused Named CAL's on weekly basis.

Is there a way to make it automated to delete for unused CAL's more than 48 hours.

Using latest version of Qlikview , Appreciate your help in this.

Thank You,

Ryan

1 Solution

Accepted Solutions
singhpooja
Contributor III

Re: Automatic deletion of named CAL's

Hi Ryan,

You can filter your data from script level and can mention following in from statement...

From.....FilePath.... where CAL licenses<50

by above statement you will get only those data where CAL licenses is <50.

Thanks,

6 Replies
Highlighted
deepaktibhe
Valued Contributor

Re: Automatic deletion of named CAL's

Hi,

For named cal deletion there is no automatic way to do this activity you have to remove named cal manually.

Thanks

ryansolamen
New Contributor III

Re: Automatic deletion of named CAL's

Hello Deepak,

Thanks for your time,

Is there a way to get triggered when leased Named CAL licenses reach around 50?

Thank You,

Ryan.

singhpooja
Contributor III

Re: Automatic deletion of named CAL's

Hi Ryan,

You can filter your data from script level and can mention following in from statement...

From.....FilePath.... where CAL licenses<50

by above statement you will get only those data where CAL licenses is <50.

Thanks,

ryansolamen
New Contributor III

Re: Automatic deletion of named CAL's

Hello Pooja,

Thank You,

Could you please help, "From...FilePath", is it in QMC?

Thank You,

Ryan

singhpooja
Contributor III

Re: Automatic deletion of named CAL's

Hi Ryan,

Not in QMC you can implement this in edit scrip from where you are extracting your data.

Requesting you to share some sample data so I can help you in scripting.

Thanks,

ryansolamen
New Contributor III

Re: Automatic deletion of named CAL's

Thank You Pooja,

Had created report using script and it solved.