I need to modify an existing P&L table with several scenarios (using the Vizlib solution with external Excel table).

Is it possible in a P&L table to use different factors per line?

sum(  Value* $(=PL_View_Factor_Best) )

I get the right calculation, when the factor is the same for all lines, but when using different values or even a conditional value for different scenarios, it returns no value.

Is there another/better way to solve this?

Bonjour,

j'aimerais reproduire ce graphique ci-dessous sur qlik cloud mais je ne sais pas comment m'y prendre. ça a l'air d'une boite à  moustache mais c'est un graphique combiné. J'arrive à faire les barres pas l'espèce de bâton.

Merci d'avance pour votre aide.

Hi,

Can somebody guide me through creating an application that has two variables vStartDate and VEndDate which will be configured by the user of the application (not in the load script but in the dashboard) and with the reload button the corresponding data will load?

Hi Team,

We need to encrypt PII columns from the source and also need to decrypt them if needed.

Any ideas how can we do it  .

Sources : Oracle, SQL Server

Target: Postgresql 

Regards,

Gayatri,

we are working on building some solution around qlik task log. We want to analyze qlik task log at some interval and parse all qlik task log. Parse log and if there's any failure or warning, we want to highlight on dashboard that will be built on some other tools.

Is there way we can fetch from replicate server (window server), do parsing ?

Hi all,

i'm trying to login to qlik using a JWT token but when i try to post to https://horsadev.eu.qlikcloud.com/login/jwt-session with the the web integration id and the bearer token i get the following error.

the token is made up like this:

user details: name sub and email are the exactly like the console.

any idea of what can go wrong here?

thanks,

Loris

Hi Team

I'd like to know the requirements of network direction (e.g. from the source to Qlik, or bidirectional flow) between the source and Qlik Replicate and also the target and Qlik Replicate to configure the firewall rule between them, but I couldn't find any information about it. Could anyone let me know what kind of traffic flow should be necessary for the source and the target?  

Thank you

Hi, I would like to calculate rolling sum like in the table below. Data should be grouped by column "Family". For each quarter I want to take a look at current quarter and 2 quarters backwards. Any idea how to achieve this in script editor? I am not interested in set analysis using rangesum - above combination. Column "Quarter" comes from fiscal master calendar.

Thank you.