Stack Overflow
Stack Overflow

Questions tagged [qlik-expression]

Qlik expressions are defined in the Expression Editor.

96 questions
0
votes
2 answers

Combine to Fields in one Qlik Sense Filter

I have 2 Fields and I need to combine them in one field. Is it possible to get this result in Qlik Sense? I do not want concatenate but get the result in table
Rachel F
  • 1
0
votes
1 answer

QlikSense Set Analysis - Sum Less than HH:MM Format

I am trying to calculate a sum where certain Time criteria are met. My date column STime is stored in a HH:MM format (13:15, 17:25, etc.). I have a variable, vCurrentTime, in the same format, calculated as: TIME(NOW(), 'HH:MM') Here is what my data…
bodega18
  • 596
  • 2
  • 13
0
votes
1 answer

Can anyone tell me what's wrong in this Qlik Sense expression

LOAD if(Year(max(FISCAL_YEAR))=Year(Today()), Year(max(FINANCIAL_YEAR))) as Curr_FY, if(Year(max(FISCAL_YEAR))=Year(Today()), Year(today()-1)) as Prev_FY Resident [data_table]; Let Current_FY = '=Curr_FY'; Let Last_FY =…
aarav
  • 5
  • 2
0
votes
0 answers

Logic for showing only Company related to particular financial year in table chart in Qlik sense

(FINANCIAL YEAR) --- Its a filter COMPANY FINANCIAL_YEAR A 2021 B 2022 C 2021 D 2021 E 2022 F 2022 I have a table with different companies. The…
aarav
  • 5
  • 2
0
votes
1 answer

Subtracting Current year Rank from Previous Year RANK in Qlik Sense

I want to show (current year rank - Previous year rank) in a dynamic way. That means if new data is loaded its automatically calculates the rank and displays. Company RANK Financial_Year A 21 …
aarav
  • 5
  • 2
0
votes
1 answer

Set analysis Qlik sense - Set analysis - Date beetween last month of last year and current month of the year

i have a column which name "Period" and i have last 18 months ( janvier 2021 to novembre 2022) In my graph i want show only month december 2021 to novembre 2022. I would like to show months beetwen last month of the year and current month. Thanks…
Juji
  • 11
  • 6
0
votes
1 answer

Concatenate all values up to current date

Say we have a table of products and the year in which each product was sold. Using Qliksense, I would like to add a column that concatenates all products that were sold up to the respective…
otwtm
  • 1,779
  • 1
  • 16
  • 27
0
votes
1 answer

Variable in Set Analysis Not Capturing Data correctly

I used the following set analysis to capture the next date on column Next Repair Date =DATE(MIN({<[Next Repair Date] = {">=$(=TODAY())"}>} [Next Repair Date])). Next I stored the expression into a variable and used another set analysis to capture…
George
  • 39
  • 3
0
votes
1 answer

How to remove records when ID has at least one related measure = 0

Essentially, with reference to the table, I want to exclude all matching IDs in this case C123 because it has at least one of the UsedResources = 0. Any help or advice would be very appreciated…
LoKi_Asterix
  • 7
  • 3
0
votes
1 answer

Count when 2 columns are empty on QlikSense

I need some help to count the number of line empty in 2 columns on QlikSense formula. In the example, when the column "Item" is filled, I would like to count the number of lines which have both "Info 1" and "Info 2" empty. In this case it should be…
Wil
  • 47
  • 4
0
votes
1 answer

Qlik Sense Button selecting errors (duplicates)

I'm very new to Qlik Sense and doing my very first button for Qlik report (table chart). Button should select "errors", or in another words, find out if there's the same vaccination date (Time column in my report) for the same person (Owner column…
Lena
  • 1
  • 1
0
votes
1 answer

qlikview - count based on a count condition

I have the following table. order_number 100 101 101 102 103 103 103 104 104 I'd like to create an expression which counts instances where order_number occurs only once. Example - 100 and 102 do not repeat, while 101, 103…
Bhargav Gorantla
  • 5
  • 2
0
votes
1 answer

How to limit data on line chart to latest month on QlikSense?

I'm trying to create a line chart with the data for only the current month. My date field is called PurchaseDate. I use this also for the 'Date Range Picker' widget in my dashboard. My dimension is PurchaseDate and my measure is PurchaseVolume. My…
user42
  • 871
  • 1
  • 10
  • 28
0
votes
1 answer

Create a single dimension from multiple fields

So essentially I want to create a single dimension by using their respective column/filename, say a Listbox called Asset, to make a selection on this laptop, desktops, server, and tablet. Many thanks. enter image description here
LoKi_Asterix
  • 7
  • 3
0
votes
0 answers

Qlik Straight table that ignores selection but still show partial link to that selection?? Set analysis

Sorry if this is a dumb question. I’m not too sure if this can even be done with Qlik’s model. But is it possible to use set analysis to ignore the current selection except one field linked to that selection (InvestmentID). I have a table of owners…
Pinepenny
  • 11
  • 3
1 2
3
4 5 6 7