Stack Overflow
Stack Overflow

Questions tagged [qlik-expression]

Qlik expressions are defined in the Expression Editor.

96 questions
1
vote
1 answer

How to Display Latest Weeks Volume by Default in Qlik Sense

I am looking for some help in displaying a set of numbers on my dashboard but I need to display the latest week whenever the dashboard is open but also allow the user to change the week that they are looking at through the filters. My data is the…
Michael Owen
  • 365
  • 3
  • 20
1
vote
1 answer

Insert values to a previous table in Qlik Sense

I'm trying to insert values in a tabla with values inside, like this table: If you look at the column "202001" and row 22 at the end, it is null, so I want to insert manually any value. It is null because that value it's not inserted to the…
Sebastián
  • 437
  • 5
  • 19
1
vote
0 answers

Qlik sense problem with filtering panel and a graph

I am trying to move the old excel to qlik sense, there is a graphic that is made from the previous day. Then that graph has the dimension of date and measurement has the sum of the amounts per month. So filtering this by day can be done with a…
Sebastián
  • 437
  • 5
  • 19
1
vote
0 answers

Minimum date against each policy

I have 2-3 multiple policies with same policy no like if i have policy 00/34 then there is 2-3 multiple records of this policies but other columns of this policy is different only policy_no is same .. i want to get minium date against policy like if…
Bakhtawar Ashiq
  • 63
  • 1
  • 9
1
vote
0 answers

policy status in script qlikview

i script but there is some problems image If there is multiple policies then i want first record which has min date always as "new" because this record came first against specific policy .. and other record which has same policy consider as "renew"…
Bakhtawar Ashiq
  • 63
  • 1
  • 9
1
vote
1 answer

QlikSense expression to find average duration over a period of time

I want to find the overall duration in hours over different periods of time. ie. once I add filters such as 'October' it should show me the overall hours for that month. I want to count duplicate lessons for multiple attendees as 1 lesson. ie. the…
toothsie
  • 245
  • 3
  • 10
1
vote
2 answers

AVG of the last 7 days not returning results

I have an expression to give me the AVG of TIMETAKEN in the last 7 days but it isn't returning any results. =AVG({}TIMETAKEN) I can get yesterdays AVG with this and it…
Matt
  • 14,906
  • 27
  • 99
  • 149
1
vote
1 answer

Qlikview use IN rather than = in a variable in an expression

I have a variable in an expression that SELECTS bottles. sum({$<[PCC] ={"$(=concat([MCC],'","'))"},[RCPT] ={'Bottle'}>}[Amount]*-1) I would like it to be able to select where RCPT equals bottle OR laptop.
Matt
  • 14,906
  • 27
  • 99
  • 149
1
vote
1 answer

QlikView expression for last 12 months & DISTINCT & not changed by selections

I have a few expressions: =COUNT(SUPP) Gives me 9316 which is correct as it is the total number. =COUNT(DISTINCT SUPP) Gives me 3429 which is correct as it is the total distinct number. =ROUND(Sum( if((Date(MonthName(MMMYY),'MMM-YY')) >=…
Matt
  • 14,906
  • 27
  • 99
  • 149
0
votes
0 answers

Qlik Sense - Ignoring Filter in AGGR Set Expression

I wanr ro build a KPI for an average value of patients in the selected year - means I want to include the selected year as filter but want to use all 12 months and all quarters: Avg(Aggr(Count( {$ * (
Max
  • 61
  • 2
  • 7
0
votes
1 answer

prevent Qlik default "replace with" and "convert to" when dropping extension on sheet

I am developing a Qlik extension whose purpose will be to export charts. I want to prevent the Qlik default behavior of "replacing with" and "converting to" when dropping my custom objects "extension" onto an active sheet. I did not see any thing on…
user1518071
  • 49
  • 2
  • 8
0
votes
0 answers

Qliksense how to search for a string across multiple text columns Logical OR

I have seen the answer to this attempted across multiple sources, but many of the solutions seem outdated or to simply not work or are Qlikview instead of qliksense such as:…
CJJ
  • 75
  • 9
0
votes
2 answers

Replace null values with previous numbers

I'm trying to get previous numbers for the highlighted period, but the below doesn't work. If(Len(Request) = 0 , Peek(NewRequest), Request) as NewRequest This is how its looks at the front end in a straight table. enter image description here
LoKi_Asterix
  • 7
  • 3
0
votes
1 answer

Looking to upgrade Qliksense from May 2021 to August 2022 version

We have previously installed Qliksense May 2021 version. We want to upgrade Qliksense from May 2021 version to August 2022 version. Database which we are using is postgres database. Scenario 1: If we try following process, will our Qliksense…
Dnyanoba
  • 1
  • 2
0
votes
1 answer

Previous month expression

I need help to get a dynamic expression for the previous month (December 2022) compared to the current year's month, January 2023. Perhaps the attached might provide some more clarity.
LoKi_Asterix
  • 7
  • 3
1
2
3 4 5 6 7