Hello friends,

I want to find the correlation between certain criteria of our products and sales. For example our products have a certain size, color and material. I want to know which of these attributes correlate strongly with sales and which don't. Is that possible to do within Qlik Sense?

Thank you.

New book published by Packt - Qlik Sense: Advanced Data Visualization for Your Organization in December 2017 authored by Dr. Christopher Ilacqua et al.

Qlik Sense is powerful and creative visual analytics software that allows users to discover data, explore it, and dig out meaningful insights in order to make a profit and make decisions for your business. This course begins by introducing you to the features and functions of the most modern edition of Qlik Sense so you get to grips with the application.

The course will teach you how to administer the data architecture in Qlik Sense, enabling you to customize your own Qlik Sense application for your business intelligence needs. It also contains numerous recipes to help you overcome challenging situations while creating fully featured desktop applications in Qlik Sense. It explains how to combine Rattle and Qlik Sense Desktop to apply predictive analytics to your data to develop real-world interactive data applications. The course includes premium content from three of our most popular books:

• Learning Qlik Sense: The Official Guide Second Edition
• Qlik Sense Cookbook
• Predictive Analytics using Rattle and Qlik Sense

What You Will Learn:

• Build simple visualization models with Rattle and Qlik Sense Desktop
• Get to grips with the life cycle and new visualization functions of a Qlik Sense application
• Discover simple ways to examine data and get it ready for analysis
• Visualize your data with Qlik Sense's engaging and informative graphs
• Build efficient and responsive Associative Models
• Optimize Qlik Sense for sales, human resources, and demographic data discovery
• Explore various tips and tricks of navigation for the Qlik Sense® front end
• Develop creative extensions for your Qlik Sense® dashboard

Author Bio:

Dr. Christopher Ilacqua

Dr. Christopher Ilacqua is the research director of product validation at Qlik®. He has been working with leading customers and partners in the US for more than 3 years garnering feedback on Qlik Sense. Chris has over 25 years of experience in the field of planning and business intelligence, and he has established himself as a leading expert by advising, designing, and implementing hundreds of planning and business intelligence applications.

His research interests focus on big data, data governance, mobile BI, SaaS, business collaboration, and cloud-based solutions.

Hi All,

i have a data - pre pandemic and post pandemic. I have pre calculated weekday averages for pre pandemic period.

For eg Monday avg = 14, Tuesday avg = 13.....Friday =10 etc

Now, i want formula to pick up the value of latest date from data  then pull the pre pandemic value for same weekday by checking  condition if the weekday of the latest date is equal pre pandemic weekday avg

Lets say today is friday and value is 3,  pre pandemic avg for friday is 10 as per pre calculated field. The final output should be 3 by 10 which is 30%

Attaching the sample data for reference

Hi All,

I am new to Qlik. Can anyone help with the formula to get the weekday name for the latest date the data. 

Also, i want to use this calculated latest weekday to compare with another existing weekday field in order to fetch a value. How can i use this in that expression / set analysis.

Any help would be appreciated 

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

This is my first job and I have started working in Qlikview/Qliksense, but seeing the job market I don't think that the future in this technology is good? What should I do, what all visualisation tools should I pick up?

Hi all

I want to load my script from datebas but my master calendar doesnt work ok. This appears:

This is my mastercalendar script:

How can l solve it? 

Hope can help me, thanks

Hi all,

I have 2 data set, they don't have any PK.

1. Orders data:
These are the orders being placed by customer.

2. ShopperStock:
Stock detail of each outlet

Desired Outcome:
If multiple similar orders are in queue for a specific shop then it must deliver them according to the order placed, if not then it's an error/ red flag.
I have attached .qvf & excel for better understanding.

Please assist. Thank you.

hi!

I have the following task - count only those clients, who were active in current month AND made their first order in the same month.  In particular, i need to build a formula where current month is compared with the 1st purchase month. 

This is simplified example, as i have a lot of clients and periods in my original datamodel.

I know set analysis is calculated once per chart disregarding dimension value per row, but maybe there is a workaround?

Thank you!

count( {< Client = p(<Month = 1stPurchase >) >} Client ) 

Hello everyone, Im a begineer in qlikview. I have 2 tables, in the table 1 I have Policy ID and two different endorsement IDs, in the other table I have Policy ID and just one endorsement ID. How can I search for the policies that are in the table 1 but aren’t in the table 2. Using the combinations of Policy and enforsement.

Thanks!!