Hello!

We have QlikSense on prem; at the authentication level, we would like to connect a website where users authenticate using Office365 accounts, to the QlikSense application.

I'll try to explain our need: we have a website; users authenticate with their Office365 accounts. They exists also on QlikSense in the users list because the list is automatically updated every day. I want that when a user log in into the website, he is authenticated also on QlikSense. 

How can I accomplish this?

I tried to explore the solutions in the documentation, bot got lost.

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.

Hi there 🙂

I have a list of products with list prices and different valid-from dates to this prices. Now I simply want to show only the newest valid-from dates (one per product). Thats it 😄 

Coud you please help me out with the script function. Attached you find the table load.

Thanks a lot!
Pesche

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?

I need to export data from a straight table as a CSV file without BOM and semicolon formatted. 

In other cases I have been running a vb script that exports data, but I havne't been able to find the one mentioned above.

I also have another request,which is to add one first line with a fixed text. Any suggestions.

We are using QlikView 12.60

/John

I made a measure for taking into account the efficiency of certain producers 

(
	Sum(
    	Aggr(
        	Count( {< ACTION_CODE = {'LABOR_OFF'}>} distinct MainSFC) * Standard_Time,
            MainSFC)
	)
)
/
(
	Count( 
    	distinct WorkingDay) 
        * 7.5 * 60)

And it works fine for the single producer. I want to abstract this, make one that takes into consideration ALL of the producers/employees, so in my mind I tried to do: 

(
	Sum( {<Employee=>}
    	Aggr(
        	Count( {< ACTION_CODE = {'LABOR_OFF'}, Employee=>}} distinct MainSFC) * Standard_Time,
            MainSFC)
	)
)

/

(
	Count( {<Employee=>}
    	distinct WorkingDay) 
        * 7.5 * 60)

But this doesn't work, and gives me null values. How could I fix 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,