Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting 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 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?
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,
In terms of features, is there a simple guide that compares Reporting Services with NPrinting?
For example, can you export the entirety of a sheet not just 1 page?
Can you create power point packs? word documents?
Reporting services looks interesting from an easy to use end to end perspective but just want to be sure of what I will get before moving to SAAS.
Thanks
Martin
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
Wondering about Qlik Talend Data Integration Sessions? There are 11, in addition to all of the Data & Analytics. So meet us in Orlando, June 3 -5.
Join us on May 15th at 11 AM ET to discuss the Qlik Ideation Process. Bring your questions.
Browse our helpful how-to's to learn more about navigating Qlik Community and updating your profile.
Your journey awaits! Join us by Logging in and let the adventure begin.
Qlik enables a frictionless migration to AWS cloud by Empresas SB, a group of Chilean health and beauty retail companies employing 10,000 people with 600 points of sale.
Qlik Luminary Stephanie Robinson of JBS USA, the US arm of the global food company employing 70,000 in the US, and over 270,000 people worldwide.
Join one of our Location and Language groups. Find one that suits you today!
A private group is for healthcare organizations, partners, and Qlik healthcare staff to collaborate and share insights..
Qlik Communityの日本語のグループです。 Qlik製品に関する日本語資料のダウンロードや質問を日本語で投稿することができます。
Welcome to the group for Brazil users. .All discussions will be in Portuguese.
Hear from your Community team as they tell you about updates to the Qlik Community Platform and more!