Hello All,

 I want to replace null, '-' Value with 0 (Numeric Zero) by Script level or sheet level.

I tried below syntax,

 If (isnull(YourExpression),0,YourExpression)

but it's not working.

Kindly suggest.

Thanks,

Pooja

Hi there, direct question: are user-based subscription models still available ? I.e., are Qlik Sense Business and Qlik Sense Enterprise SaaS still purchasable?

If not, what happens to customers? Are they forced to change plan and move to capacity-based models?

I really hope no!

We are in the process of migrating our existing QlikView server to AWS.

Please could you let me know...

1. Is there “Amazon Machine Image (AMI)” available for QlikView server to install on AWS
2. Is there any way to upload existing server configuration to new server i.e. like copying certain files so that all document folder mappings and app properties/schedules will be ported to new server?

Dear Qlik Community,

I have the following problem.

I have a table (QVD) with very many columns. e.g. ccPersonlist, ccPersonlist_M_1, ccPersonlist_M_2, ccPersonlist_M_3, ... ccPersonlist_M_40...

the number of columns can change.

I want to combine this many columns in one column.

I would combine the columns with Concatenate.

But for this I would like to build a loop that queries the possible number of columns before and includes all columns that start with ccPersonlist.

How can I do this? Do you have any ideas? How can I read all column names from the QVD beforehand and build them into the loop?

Thanks a lot

In qlikview I often use dynamic caption and window title  for a chart (='text '& $(variable)

The name of an object in Nprinting  contains  the object ID + caption of the object (or window title ?).

The problem I have is that when the dynamic caption changes the object name in Nprinting changes,.

So in the Nprinting template the object cannot be found.

I would like to know how other users solve this without having to modify the template when the title or caption changes.  A static window title is not an option.

Hey All, 

I've been trying lately to connect Qlik sense to a Python SSE. I've tried the following link

https://github.com/nabeel-oz/qlik-py-tools

But kept getting errors while installation.

Has anyone lately tried another method to apply forecasting in qlik?

Thanks

I have applications connected to a SharePoint link, and they use my credentials for authentication.

As a result, my colleague cannot run these applications with the data load script since they don't have access to that connection.

Is there a way for both me and my colleague to use a common SharePoint connection on our respective sides?

Tanks !

Hi everyone! I am creating an input variable which allows me to change the information shown in a line chart. I have created 3 entries for this input and it is displayed as 'Drop-down'. The problem is that whenever I open this drop-down, appart from the 3 entries created, there is another value whose label is '--SELECT--', but I want to avoid it. 

Anyone knows which is the problem?

Thanks in advance!