• #### Thread Count aggregation of rowsCount aggregation of rows

Hello everyone,   I have the following straight table with Bucket and Category as dimensions. The users are also expected to have a third dimension, country, in the form of a list box to slice the data. Not seen...
• #### Thread Sumif method on QlikSumif method on Qlik

Hi guys, just started to learn Qlik expression, and any help on what I am looking for, would be grateful appreciated.   I have 3 columns,      - Column A contains Years [2016, 2017, 2018] &...
• #### Thread Choose the biggest of value between two, or more, variables, to base a calculation onChoose the biggest of value between two, or more, variables, to base a calculation on

Hi all,   I got abit of a problem, I got dataset like the one below. ID Value1 Value2 Value3 A 8 6 2 B 7 8 . C 5 5 0 D 12 . 1 E . 4 4 F . . . I also have a silder (single value) with the range between 2...
• #### Thread Jouer avec des logosJouer avec des logos

Bonjour, j'aimerais pouvoir jouer avec des logos dans Qlikview. Après quelques recherches infructueuses je m'en remet à vous.   Le principe est assez simple. j'ai plusieurs filiales dont les d...
• #### Thread Set analysis with 2 nested expressionsSet analysis with 2 nested expressions

Hello everyone,   I wish to sum the accounts whose amount is negative knowing that the balance of the account is calculated according to the formula TOTAL below.   TOTAL = sum (...
• #### Thread Rangesum set analysisRangesum set analysis

Hi community,   I am loading the following with Qlik Sense: LOAD SAMPLED,     NODE,     PHYSICALINTERFACE,      NODE&'/'&PHYSICALINTERFACE as Resourc...
• #### Thread Assistance with writing an expressionAssistance with writing an expression

Hi All, I have an existing formula that works in excel that I am trying to port over to Qlik Sense.   The formula is this: =SUM(TOTAL_AP/TOTAL_EP)-SUM(ZRC_TGT_Fc/TOTAL_EP)-1   Effectively this formula is d...

Dear All Please Help about sum matrix in Pic_1 I want to make in red arrow in pic_1 sum in yellow highlight Thank Pic_1

Dear All I want to sum number that max aging (Table: MAX DAY ,Column: TOTAL ) in attach file. I will try in formula : " =sum({< AGEING = { \$(=max(AGEING,ITEM)  )}>} TOTAL) " but It sum only max at all ...
• #### Thread Expression works in Textbox but not if savedExpression works in Textbox but not if saved

Hi,   I am currently trying to make a date field. I have a field YYYYMM and I jsut want to add '-01' to the end so that I get a date format like 2010-01-01. I did it with Date(YYYYMM & '-01') and it works...
• #### Thread Text between certain occurrences of spacesText between certain occurrences of spaces

Hi community,   Is it possible to extract text between e.g. 3rd and 6th occurrence of space?   For instance how could I extract 'XMC 3 H' from the following:   'Micro Unit RTN XMC 3 H X094357'
• #### Thread Load Script dynamic Table (increasing month by month)Load Script dynamic Table (increasing month by month)

Hello,   I hope someone can help me. I have a csv-file, which I want to load. This month the columns needed are from column A to AQ. Next month it will increase by one column so that we need from A to AR, the ...
• #### Thread Difference with previous valueDifference with previous value

Hi, is it possible to calcolate at runtime the difference between values in a chart. For example, i have the next table data.     PROGRESSIVE,TYPE,DEVICE,ENERGY 1,1,a,1 1,2,b,2 1,3,c,3 1,4,d,4 2,1,a,...
• #### Thread Help Re-write aggr expression - easier applicationHelp Re-write aggr expression - easier application

Hi, Need help re-write this to an easier expression;   ((sum(aggr( sum(kWh) * sum(aggr(sum(Price), DateJoin,Pricearea,CustomerKey)) , DateJoin, Year,Month, Pricearea,portifolio,CustomerKey))    ...
• #### Thread How do I group 21 fields into one "field"?How do I group 21 fields into one "field"?

Hello there everybody!   So, I have a tiny problem with my script.   This one:   LOAD [CNAE 2.0 Classe],      if([CNAE 2.0 Classe]<'04000','Agricultura') as "CNAE",  &nb...
• #### Thread Remove newline in stringRemove newline in string

Hi,   I would like to replace all newline characters by spaces in a string.   I have tried : string.replace(input.my_string,'\r',' ') or string.replace(input.my_string,'\n',' ')   But it doesn't...
• #### Thread Sum 8 bottom values of expression, multidimensionalSum 8 bottom values of expression, multidimensional

Hello all,   I am loading data on monthly basis and I have created a report with dimensions Resource, Date, Time. What I am trying to do is to report per Resource the sum of the 8 worst values of an expression t...
• #### Thread Maximum value of sum per 4Maximum value of sum per 4

Hi community, You have helped me with this previous post : https://community.qlik.com/thread/262498?sr=stream   In short., I have created a pivot table with dimensions 'Resource' and 'CollectionTime' (The gran...

I have trouble finding it. Can someone help? Thank you.
• #### Thread Weighted Scores HelpWeighted Scores Help

Good morning folks,   I am trying to create a weighted score based on the attached.   Scores 1 and 3 should make 20% each of the overall, with Score 2 making up 60% of the overall. On the attached I just h...