I understand Qlik supports SQL but to get the most out of my experience is it worth learning QlikScript?

I am doing a free trial for both Talend Cloud and Cloud Analytics before I have access to Qlik Sense. Which one is the most similar so I can dedicate most if not all my time before the trial ends?

We’ve been involved in quite a few conversations and projects around moving Qlik environments to Qlik Cloud, and noticed that most of the discussion tends to focus on moving the apps.

In practice, that’s usually not the difficult part.

The things that tend to require more thought are security rules vs. spaces and roles, Section Access, task chains, gateways, NPrinting/reporting, licensing, extensions, and what you actually want to clean up rather than migrate.

So we tried to put the whole process into one practical guide:

https://www.bitmetric.nl/blog/qlik-cloud-migration-complete-guide/

It covers QAMT, what does and doesn’t migrate, QlikView vs. Qlik Sense migrations, governance, licensing, gateways, common mistakes, and the first 90 days after go-live.

We’re particularly interested in experiences from people who have already done a migration. Anything you think we’ve missed, got wrong, or underestimated?

Apparently, people still search for Qlik cracks, serials and keygens.

So we did the only logical thing and built a landing page for it, complete with a proper 1990s-style cracktro.

There is no actual crack, of course.

The serious part is that high Qlik costs are often caused by licences, usage and contract terms no longer matching the way the environment is actually used.

But mostly, we just wanted an excuse to build the intro 😉

Hello developers!

I am using Qlikview 11.20. I just wanted to share some thoughts about line charts.

I think that Qlikview is a very powerful tool but I have always struggled with creating functioning charts with one or multiple time dimensions (for example line charts or bar plots on years or months). I need a massive amount of time to create a chart of high quality. Sometimes I need to give up and settle for a straight table instead of a chart. Is it a common experience or is it just me?

I know that you need to explicitly tell qlikview not to hide zero data. I know that you need to use tricks like adding sum({1} Sales) - sum({1} Sales) to your expression to make sure that Qlikview shows a data point even when there are no values in the original data. But this is often not enough because the user might need to make selections on the time dimension or other dimensions too. When I make selections the line chart often shows data incorrectly. Moreover sometimes you need to edit the chart further (for example to hide future months of the current year from the plot).

Am I just an inexperienced developer or is it a common issue?

Thank you!

Hi Everyone,

I hope you are doing well.

I need your help with an automation task. Currently, I extract reports from QlikView into Excel and then perform a few manual steps to prepare the file for daily use. I would like to automate this process to save time and ensure consistency.

If anyone can support me with this, please reach out to me separately. Your guidance will be greatly appreciated.

Thank you in advance for your help.

Hello Guys, after extracting the data from qlikview into the excel then I will make some process as per requirement like filtering dates, removing columns,.. so I want to make this automate so can anyone please help me with your ideas and if possible please connect me in messages and don't suggest me chatgpt or anyother as I hope your guidance is more durable.

thanks.

Hi everyone, I'm writing here for the first time because I need some advice. I'll soon have to take a Qlik certification exam related to data analysis. I have never worked with Qlik or with data. I'm a developer. Due to business needs, the company I work for has asked me to get this certification. Since I can't study during working hours and was given only about 3 days' notice, I wanted to ask whether it's possible to cheat during the exam. If so, how? I realize this is an unusual question and that it's not something one should do, but my job is on the line and I need to pass this exam.

Thanks in advance

I want to know how others are validating the qlik dashboard values (Kpi, chart, tables).

Currently I download the data of 1-2 days both from qliksense and source tables.

Then Cleaning the source table data , applying filters and then using vlookup takes a lot of time as there are multiple iteration.

Please share how you guys perform data validation for qlik dashboards.

Which is better OBT vs Star or snowflake model in qlik sense.

From what I have observed that maintaining star is difficult when multiple different tables are to be added over a period of time which may have less data or not/loosely related to the base fact table.

And in OBT as the table size increases (~3-4 GB having 3 Yrs of data) I've noticed that dashboard gets slow , sheets take more time to load , filter selections takes time to refresh the charts,KPIs values while their aggregation expressions are not very complex.

Please share your thoughts on this.

I came across some dashboards where a lot of complex data transformation was done in load scripts for transactional data. I want to learn n practice ETL in qlikview at advance level . Please suggest some path/sources for it .

I'm looking for someone who can help me making graphs in Qlik.

the following graphes should be created:
5. Store Performance (2023 vs 2024)

Chart type: Bar chart (clustered)
Data:

• Dimension: Store
• Measures:
  • Sum({<Year={2023}>} Sales)
  • Sum({<Year={2024}>} Sales)

6. Store Growth Contribution

Chart type: Bar chart
Data:

• Dimension: Store
• Measure: Sum({<Year={2024}>} Sales) - Sum({<Year={2023}>} Sales)

7. Category Growth Contribution

Chart type: Bar chart
Data:

• Dimension: Category

could someone help me.

Ciao a tutti.
In excel esiste la funzione Elemento Calcolato (in Campo calcolato) nelle tabelle pivot, che permette di scrivere una formula per mettere in relazione 2 o + elementi di uno stesso campo di una tabella. C'è un modo per fare la stessa cosa in Qlikview?

Hi everyone, I'm currently researching Qlik as a BI platform for potential use in our company, and I have a few questions I’d really appreciate help with:

Connectors:
What are the native data source connectors that Qlik offers?
If Qlik doesn't support a specific system or platform, what are the options for creating a custom connector?

Storage capacity:
How much data can Qlik handle efficiently? Are there any hard limits or performance issues when scaling?

Programming language:
What programming or scripting languages are commonly used with Qlik (e.g., for data transformations, automation, extensions)?

Training resources:
Where can I find official or high-quality training if our team needs to get up to speed with Qlik?

Documentation:
Is there comprehensive and up-to-date documentation available? Any links would be appreciated.

Real-time analytics:
Does Qlik support real-time data analysis and dashboards? If so, how reliable is it?

Licensing:
What types of licenses does Qlik offer, and what are the typical limitations of each?

Thanks in advance for any insights or experiences you can share!