• Count 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...
    Igor Markovic
    last modified by Igor Markovic
  • Sumif 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] &...
    Sabir Guiri
    last modified by Sabir Guiri
  • Choose 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...
    Agner Schibler
    last modified by Agner Schibler
  • Jouer 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...
    Benjamin KASSI
    last modified by Benjamin KASSI
  • Set 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 (...
    sophie durricague
    last modified by sophie durricague
  • Rangesum set analysis

    Hi community,   I am loading the following with Qlik Sense: LOAD SAMPLED,     NODE,     PHYSICALINTERFACE,      NODE&'/'&PHYSICALINTERFACE as Resourc...
    Nikos Tsachalis
    last modified by Nikos Tsachalis
  • Assistance 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...
    David Robinson
    last modified by David Robinson
  • Please Help about sum matrix

    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
    chanon wittayanupong
    last modified by chanon wittayanupong
  • Help me please

    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 ...
    chanon wittayanupong
    last modified by chanon wittayanupong
  • Expression 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...
    Jennifer Schneidmüller
    last modified by Jennifer Schneidmüller
  • Text 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'
    Nikos Tsachalis
    last modified by Nikos Tsachalis
  • 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 ...
    Christian Wylezol
    last modified by Christian Wylezol
  • Difference 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,...
    Luca V
    last modified by Luca V
  • Help 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))    ...
    Marius Larsen
    last modified by Marius Larsen
  • 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...
    Rodrigo Alves
    last modified by Rodrigo Alves
  • Remove 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...
    LionelBdv
    last modified by LionelBdv
  • Sum 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...
    Nikos Tsachalis
    last modified by Nikos Tsachalis
  • Maximum 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...
    Nikos Tsachalis
    last modified by Nikos Tsachalis
  • Download Expressor Link

    I have trouble finding it. Can someone help? Thank you.
    Retko Okter
    last modified by Retko Okter
  • Weighted 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...
    Gareth Lloyd
    last modified by Gareth Lloyd