• 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...
    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
  • Busy hour, pivot table column calculation

    Hi community,   I am using Qlik Sense and I would like your help with the following:   I have created a pivot table with 2 dimensions and 1 measure. Dimensions are Sampled( time series) and ResourceName( w...
    Nikos Tsachalis
    last modified by Nikos Tsachalis
  • Combining scores expression help

    Morning guys,   I'm after some more expression help if I may please!   In the sample data attached I'm trying to create the following overall scores for a dashboard. The three scores I'm stuck on are as foll...
    Gareth Lloyd
    last modified by Gareth Lloyd
  • Simple expression help

    Morning guys   Quelle surprise, I'm after a little help please.   I’m trying to find the number of PO’s raised retrospectively. Logically, the way to work this out would be to look where the ord...
    Gareth Lloyd
    last modified by Gareth Lloyd
  • Expression Help

    Good morning, I require some help if possible please. I have an expression that counts the number of invoices overdue for suppliers - count({<[Days Overdue]={'>0'}>}[$(=CName)])   I am now trying to ...
    Gareth Lloyd
    last modified by Gareth Lloyd
  • Garbage after expression: 'AS'

    Hi All,   Cannot see what is wrong with this code. I am trying to create a new dimension.   =If([Policy Holder Age] < 60,     '< 60',     If([Policy Holder Age] >...
    Finbar Gillen
    last modified by Finbar Gillen
  • Percentages help

    Good morning all,   I am trying to work out the % of "spend" still waiting to be paid.   However, my expression isn't helping and I'm starting to pull my hair out!!   I currently have sum ([Spend Exp...
    Gareth Lloyd
    last modified by Gareth Lloyd
  • Show top 80% of spend

    Good morning guys I'm after some more help if possible please.   Supplier YTD Spend (£) Supplier C 55082544.02 Supplier N 7080656.50 Supplier P 6481116.09 Supplier L 8312827.59 Supplier D 26443274.72 Supp...
    Gareth Lloyd
    last modified by Gareth Lloyd
  • Sorting by Expression Question

    I am trying to create a table (or chart) that sorts customers based on the net difference in sales between this year and last year. Ideally, I would like to see the top 10 customers (the highest net increase) and the ...
    Joe Gorman
    last modified by Joe Gorman
  • Count week between two dates

    Hello everyone,   Someone here could help me to calculate the number of weeks between two dates?   Like for example: =Week(DATE1 BETWEEN DATE2)   Thank you, hope that you can understand my question.
    Rafael Marvila
    last modified by Rafael Marvila
  • Sub query in Chart expression

    HI , I try to find sub query in this blog but cannot found related.   Somebody help me think about transforming sql code below to qlikview expression in chart object please.   select store_code,sum(sale) ...
    Chanon Hemtanon
    last modified by Chanon Hemtanon
  • How to create year to year comparison bar chart?

    Dear all,   i need to create something like Year to Year comparison Bar Chart, with Avg as well, here's how it looks like as an image file from my user.   How to create a  year side by side comparis...
    Jim Chan
    last modified by Jim Chan
  • Is it possible to create a table with input from user?

    Hi everyone, I would like to create a table where some columns has data validation and just one column has input from user. See the example below made at MS Excel that's represented what I mean:   And, there...
    Pedro Goecking
    last modified by Pedro Goecking
  • Parâmetro em função.

    Pessoal, Criei um text conforme abaixo: =$(Nota('TAXA_EMP_ATEND_PARC'))   Nele eu quero obter uma nota a partir de um indicador. Na "variável" Nota está definida conforme abaixo: $(Nota_Ajustad...
    Carlos Zazula
    created by Carlos Zazula
  • Help with expression >=1

    Hi,   I want my expression to show 1, when the value is >=1.   =((sum(k_faktor) * sum(GDTNORM) / sum(aggr(if(avg(kWhTemp) >=17, 0, 17-avg(kWhTemp)), Dato))) + ('1'-sum(k_faktor)))   feks: w...
    Marius August Larsen
    last modified by Marius August Larsen