Stack Overflow
Stack Overflow

Questions tagged [qlik-expression]

Qlik expressions are defined in the Expression Editor.

96 questions
0
votes
1 answer

Categorise measures to use as dimension

I am trying to build a table where I am summing multiple measures and would like to categorise them into dimensions. To simplify, I have a table in the warehouse with the below schema: Profitability(month_end_date, product_type,…
Sarah
  • 67
  • 8
0
votes
1 answer

How to generate total for each section in a column in pivot table on Qliksense?

I'm new to Qliksense and I'm trying to generate a table as shown below. Using the Pivot table, I came up with getting near the structure, but could not add the Total row for Amount as shown for each unique value in Name. How can I add that?
Preetham CS
  • 41
  • 6
0
votes
1 answer

QlikSense Expression Displaying only Previous Month's Values

I have started working with QS recently and I have a problem with defining an expression which will allow me to display previous month's data. I have tried creating previous month variable: vPreviousMonth = MonthName(Addmonths(Max([Calendar…
great4whale
  • 19
  • 1
0
votes
1 answer

Writing an expression in Qlik Sense: unique value with latest date?

I need some help to create an expression that gives a graph for the number of IDs in one day without repetition. As you can see in the image, one ID may have more than one entry with a different date. How can I select the ID with the latest date…
greatdsa
  • 112
  • 1
  • 1
  • 12
0
votes
1 answer

Filling Data in qlikview

I'm trying to fill each month with all the units and '0' for the missing unit, can anyone help me on this Actual data: LOAD * Inline [ Unit,Month,Sold 7511,Sep 2020,13000 7512,Sep 2020,10000 7511,Nov 2020,7500 7513,Dec 2020,5000 7511,Dec…
zouhir karim
  • 1
0
votes
1 answer

Sum() not working in Qlik Sense Data Load Editor

I've been working hard to understand Qlik, but the documentation is sparse and there simply aren't a ton of scripting examples out there to help me pick it up any faster. I'm very frustrated, so my apologies if I'm not explaining this well. My data…
CitizenKaye
  • 3
  • 2
0
votes
2 answers

Qlik view table field expression having a variable isn't working

I have scorecard dashboard on qlikview. In my table I have three fields, namely Current score, Previous score and Variance(difference of the previous two columns). I am calculation current and previous score using a similar formula, only difference…
Sidra Nisar
  • 13
  • 4
0
votes
3 answers

Qlik set analysis, partial selection of a field through modifier while ignoring the same fields selection

I have fields, score, month, region and area. I need some of the score for maximum month. But my selection boxes have month, area and region. On selection of month box the value changes although in modifier I have specified month to max month…
Sidra Nisar
  • 13
  • 4
0
votes
1 answer

Qlikview 12: prevent sheets from being selected

I have a range of multilists on a first sheet (I.e. Selection), and a range of other sheets,called databasesheet1, databasesheet2, databasesheet3, that contain a mix of data pulling from a variety of databases. The selections made by the user can…
Codingguy1
  • 17
  • 2
0
votes
1 answer

How to transform number to date in Qlik Sense expression

In a graph I'm trying to show last month with this expression: =If( [SH_historico_1.ANOMES] >= '$(=Max([SH_historico_1.ANOMES])-1)' and [SH_historico_1.ANOMES] <= '$(=Max([SH_historico_1.ANOMES]))', [SH_historico_1.ANOMES]) When I write…
Sebastián
  • 437
  • 5
  • 19
0
votes
2 answers

Qlik Sense Syntax in Data Loader Script

How it would be this query in Qlik Sense syntax in data loader script? TABLA_UTIL: SQL SELECT "PERIODO", SUM(DEUDAFINAL) as "DEUDAFINAL" FROM "DL_RG_ANALYTICS"."SH_PROVISION" PRO WHERE ORG='628' GROUP BY PERIODO concatenate SQL SELECT OL.PERIODO,…
Sebastián
  • 437
  • 5
  • 19
0
votes
1 answer

How to union two tables in Qlik Sense

I am trying to join/concatenate 2 tables, because it would be more comfortable to work because they have the "year-month" column in common. As you can see below: I just have 1 table uploaded in Qlik Sense, the 1st one. And I'm trying to upload the…
Sebastián
  • 437
  • 5
  • 19
0
votes
1 answer

How to put a label to a hierarchical dimension in Qlik Sense

I would like to know if I can set a label to a hierarchical dimension, because If I have 2 dimensions, it will show like below: That seems not beauty, so, there is a way to change this with a label or something in qlik sense? Thanks, any ideas?
Sebastián
  • 437
  • 5
  • 19
0
votes
1 answer

Change Color, move and bold text in header table on Qlik Sense

I'm trying to change text color from table, move the text to center and put it bold text from a table or a graph in qlik sense, like in the following image: That can be done without extensions? What is the alternative? any tutorial? Thanks!
Sebastián
  • 437
  • 5
  • 19
0
votes
1 answer

Is there another way in Qlik Sense to show the latest weeks data by default as well as a filter to change the week you're looking at?

I am looking to add a weekly filter onto my Qlik dashboard to allow me to change the weekly data that is displayed on my dashboard. My original idea works well as I wanted to display the latest weeks data and compare this to the previous weeks and…
Michael Owen
  • 365
  • 3
  • 20
1 2 3 4
5
6 7