# Welcome to Qlik Community

• 152,698 members
• 6,631 online
• 1,702,925 posts
• 127,370 Solutions
• # Welcome to Qlik Community

## Data Analytics

Forums for Qlik Data Analytics solutions. Ask questions, join discussions, find solutions, and access documentation and resources.

## Data Integration

Forums for Qlik Data Integration solutions. Ask questions, join discussions, find solutions, and access documentation and resources

## Qlik Gallery

Share your best Qlik apps and discuss impacts with peers! Show your work and get recognized for innovative uses of Qlik technologies.

## Ideation

Participate in Qlik Technical Previews, submit ideas, and review documentation.

## Support

Chat with us, search Knowledge, open a Case, read the latest Updates Blog, find Release Notes, and learn about our Programs.

## Events

Learn about upcoming Qlik related events, webinars and local meetups.

## Groups

Join a Group that is right for you and get more out of your collaborations. Some groups are closed. Closed Groups require approval to view and participate.

Get started on Qlik Community, find How-To documents, and join general non-product related discussions.

## Blogs

Hear directly from Qlik employees in our ten unique blogs.

## Qlik Resources

Qlik gives qualified university students, educators, and researchers free Qlik software and resources to prepare students for the data-driven workplace.

## Community Sitemap

Here you will find a list of all the Qlik Community forums.

## Recent Discussions

• No Boards Found
• New to Qlik Sense

### Current month

Hello i'm trying to create a field which will "predict" shop monthly revenue based on current average revenue. In other words im taking revenue from c... Show More

Hello i'm trying to create a field which will "predict" shop monthly revenue based on current average revenue. In other words im taking revenue from current month and divide it by days that have already passed. Then im multiplying this number by number of days that there are in month.

So it look like this :
((Sum({<[channel]={'ABC'},Yearx={'2022'},[Monthx]={'May'}>} [Revenue]))/(day(today())-1))*31

So as you can see i have put manually year, month and number of days in a month. i would like to automate this so i won't have to change it every month 🙂

But i cant figure it out

I've tried with [Monthx]=month(today()) but it doesnt work...

Show Less
• Integration, Extension & APIs

### DUO for IDP/SSO for Qliksense SAAS ?

Hi:  Has anyone figured out how to integrate DUO, which is SAML standard, to Qliksense SAAS, as IDP/SSO? Or is it just impossible because QS only supp... Show More

Hi:  Has anyone figured out how to integrate DUO, which is SAML standard, to Qliksense SAAS, as IDP/SSO?

Or is it just impossible because QS only support OIDP standard ?

We have DUO already and don't want to adopt something else unless we absolutely have to

thanks for any info,

Don

Show Less
• App Development

Hello community I'm facing an issue about add many measures on the radar chart (bundle vizualisation) we can only put 1 measure... we cannot realise t... Show More

Hello community

we can only put 1 measure...

we cannot realise the same viz like qlikview ( in order to show benchmark for example)

Is there a tips in order to realize real Radar Chart?

Tanka a lot

Show Less
• New to Qlik Sense

### Grouping and Stacking Bars Graph

Hi! I have a problem with the bar chart. Can I create a grouped bar chart and one of the bars contains two stacked measures? Thanks!
• New to Qlik Sense

### Data Type Alignment

Within Qlik Sense Hub, I am trying to create a YYYYMM table to link to several other tables. However, I cannot seem to get the data types to align bet... Show More

Within Qlik Sense Hub, I am trying to create a YYYYMM table to link to several other tables. However, I cannot seem to get the data types to align between tables so when I try to connect on this field, the connection seems poor. Both fields are coming from imported excel files and I have reviewed the fields in each file several times to ensure they are the same within the underlying excel. I don't understand why Qlik left justifies one column but right justifies the other column (see screenshot).

Any help on how to get these fields to align with each other is greatly appreciated.

Show Less
• Brasil

### Variação de preço por ano

Boa tarde, Preciso fazer calcular a "variação" do preço por ano conforme o print abaixo, pode me ajudar por favor? Muito obrigado!
• New to Qlik Sense

### Cumulative field by two dimensions

Hi team, I would like to get the field "Cumulative cost"   year contract code claim cost Cumulative cost 1 a 1 10,00 € 10,00 € 1 a 2 20,00 € 30... Show More

Hi team,

I would like to get the field "Cumulative cost"

 year contract code claim cost Cumulative cost 1 a 1 10,00 € 10,00 € 1 a 2 20,00 € 30,00 € 2 a 3 5,00 € 5,00 € 2 a 4 30,00 € 35,00 € 3 b 5 40,00 € 40,00 € 3 b 6 5,00 € 45,00 € 3 b 7 5,00 € 50,00 €

Do you have some idea? I would like to have it inside of the script.

Thank you very much,

Show Less
• QlikView Integrations

### Chart representation

Hello! I import data in te following form: Apartment ID AIR CONDITIONING HEATING BALCONY PARKING 255 YES NO NO NO 301 NO YES NO YES 075 NO NO... Show More

Hello!

I import data in te following form:

 Apartment ID AIR CONDITIONING HEATING BALCONY PARKING 255 YES NO NO NO 301 NO YES NO YES 075 NO NO NO NO 111 YES YES NO NO 023 YES YES YES YES

I would like to create a chart/table as the following:

 YES NO AIR CONDITIONING =count({},AirCond)=3 =count({},AirCond)=2 HEATING =count({},Heating)=3 =count({},Heating)=2 BALCONY =count({},Balcony)=1 =count({},Balcony)=4 PARKING =count({},Parking)=2 =count({},Parking)=3

Any idea of how I could do this?

Show Less
• App Development

### Accumulate all values up to the selected filter

I have a problem creating a Set function for accumulating all valaues up to the selected filter (Year, Month, Date). My aim is to SUM all values and d... Show More

I have a problem creating a Set function for accumulating all valaues up to the selected filter (Year, Month, Date).

My aim is to SUM all values and display them in a bar char (drill down year, month, date).

The values should be summed up to the max selection.

For example: if year 2022 is selected, all values before 31.12.2022 summed up.

 ID Year Month Date Value 1 2022 02 01.02.2022 50 2 2022 01 01.01.2022 50 3 2021 12 01.12.2021 50 4 2021 11 01.11.2021 50 5

Show Less
• App Development

### Calculate the percentile in the data array for the expression

Hello! I want to get a table chart in which I will see the following: partner, keyword, number of customers, percentile (which percentile corresponds ... Show More

Hello!

I want to get a table chart in which I will see the following: partner, keyword, number of customers, percentile (which percentile corresponds to the number of customers for this keyword inside the partner in the row).

I understand that I need to use a fractile to calculate percentiles in qlik sense, but I have not yet managed to figure out how to get a fractile to express the number of customers within a partner group for my table.

 partner keyword customers perc (fractile) p1 k11 10 0.40 p2 k33 5 0.30 p2 k22 20 0.85

Thanks in advance for any tips for this!

Show Less

Start Here

## Top Participants

MVP

23033

Employee

8883

MVP

8724

MVP

8295

Partner

8001

Employee

6556
• ### marcus_sommer

MVP & Luminary

5794

MVP

5399

MVP

4751

Employee

4006

## Blogs

### Qlik Product Innovation Blog

Learn about what's new across all of the products in our growing Qlik product portfolio.

## Blogs

Important and useful support information about end-of-product support, new service releases, and general support topics.

## Blogs

### Qlik Design Blog

All about product and Qlik solutions: scripting, data modeling, visual design, extensions, best practices, etc.

## Japan Group

### Japan

Qlik Communityの日本語のグループです。 Qlik製品に関する日本語資料のダウンロードや質問を日本語で投稿することができます。

Request to join

## Brasil Group

### Brazil

Welcome to the group for Brazil users. .All discussions will be in Portuguese.

open to all

## Deutsche User Group

### Deutsche User Group

Der deutsch(-sprachig)e Qlik-Markt bietet so manche Spezialität, die sich hier leichter diskutieren läßt.

All are welcome

## Events

### Unleash the Power of Your Finance Data

Transform financial outcomes with next-gen business intelligence strategies

Available On-Demand

## Events

### When You Liberate Your SAP Data, Everything Qliks

How Qlik helped Greene Tweed reduced time to insights by 65%

Now On-Demand

## Events

### Live Instructor Webinars

Attend a live webinar session with our expert instructors and special guests to review learning topics in the Qlik Continuous Classroom and beyond.

Live Instructors