• Average of Sum

         Hi Community. I have attached a simple data set of which I am trying to get an average for each employee. Either in a Pivot Table or straight table is fine. Just cant seem to replicate in Qli...
    Zoe Mwendabai
    last modified by Zoe Mwendabai
  • Create sub totals

    Hello,   please find attached the following figure: I want to know if it is possible to create sub totals (bolt lines) like mentioned in the figure.   Please give me a general idea because the figur...
    Alâa Eddine KACEM
    last modified by Alâa Eddine KACEM
  • How to retrieve data from 4 last week script loop ?

    I would like to make a loop that will retrieve the data of the last 4 weeks via a sql request and store them in a qvd file per week. Here is what a collegue did, but it doesn't work. PLease help !!!! set jour_calcul =...
    cedric foning
    last modified by cedric foning
  • QlikView into QlikServer formula problem?

    Hi all,   Having some trouble with this formula: =count(DISTINCT[Reference Number])   It works when I work on it in my localized version on my desktop.   Once I publish into QlikServer only this for...
    chris thng
    last modified by chris thng
  • Send To Excel: Should show hided fields as well

    Hi Team,   I have a straight table, in that i have added 20 dimensions and 1 expression. Out of those 20, i have selected only 7 dimensions as showed dimensions and have hided the rest 13 with the option availa...
    mohan krishna
    last modified by mohan krishna
  • Comparison of 2 series in line graph

    Hi,   Below are the series selection in the list box. Those series that start with F as below is 2018 Models, while start with E is 2017 Models.   F FA FB FC E EA EB EC     When F / E sele...
    Wendy Tham
    last modified by Wendy Tham
  • Prior Period Sum (Set Analysis)

    Hi All,   Trying to do what I thought would be pretty straight forward but having no luck. Hopefully putting this in front of some fresh eyes will get me where I want to be.   I have FullDate as my dimens...
    Steve Nelson
    last modified by Steve Nelson
  • FirstSortedValue  mit variablen in Diagramm

    hello everybody,   i try to find the last status with following syntax   =FirstSortedValue({<Anlage={'$(vAnlage)'}>} akt_status, -Akt_Ende,1) ,   but it is not running, please help me to find m...
    Lijun Wang
    last modified by Lijun Wang
  • Values are not matching in table and chart

    Hi Experts,   I have created one dash board by using alternate states. and implemented one straight table and one bar chart   But if applying filters bar chart and straight table values are not matching bu...
    Sudhakar Battula
    last modified by Sudhakar Battula
  • why we use Plug-IN?

    please help me why we use plug-in and AJAX?@
    Hareesh Kommineni
    last modified by Hareesh Kommineni
  • Previous week

    I am using this set analysis =Sum({$<[CalendarLink]={'(=vPreviousWeek)'}>}OTHours) to get my previous week data, this expression is not giving me the right result.   My variable is as follows: =date(Calen...
    Haseeb Rasheed
    last modified by Haseeb Rasheed
  • Strange problem with opening the QVW file

    Dear All,   I'm facing this problem for few months now and I haven't been able to find a solution, so maybe some of you had similar case and know how to solve it.   I cannot open one of our qvw files on se...
    Malgorzata Dabrowska
    last modified by Malgorzata Dabrowska
  • If i create input box,and input one value,can i use this value in my select sql?

    for example:     my select sql: select * from tablename where columnname = 'my input value';   when i click select button,the page can refresh the data.
    Yuan Zaimin
    last modified by Yuan Zaimin
  • Calculate sum for selected year

    Hi, I need help on this if anyone knows.   Below are my QlikView file and for the questions:   1 Calculate total revenue of all stores for Year 2007? (question 3 in Qlik) 2. Year 2006: Region Missouri:&nb...
    John Bro
    last modified by John Bro
  • Rolling 12 months calc, not showing correct figures

    Hi all, hope you're having a good day.   I am hoping, you can solve my head scratching query, around a rolling 12 month calculation not working.   As per my attached qvd, there are two tables.   Firs...
    Marcus Steggall
    last modified by Marcus Steggall
  • Dont count a value from a different column

    Hi,   I have created an expression to determine a compliance rate on my dashboard but i now need to be able to exclude specific rows with a given value from a different column......   Current expression i...
    Peter Derrington
    last modified by Peter Derrington
  • Create sub totals

    Hello,   please find attached the following figure: I want to know if it is possible to create sub totals (bolt lines) like mentioned in the figure.   Please give me a general idea because the figur...
    Alâa Eddine KACEM
    last modified by Alâa Eddine KACEM
  • Change background color of missing

    Hi,   I have these 2 tables below     Now I want to create a pivot table and transpose the date so it looks something like this:       question is how do I identify the null cells ...
    Kim Burata
    last modified by Kim Burata
  • Multiple Apply map

    Hi Experts, I have requirement on multiple lookup/ applymap Below is data: Table_1: NAME ID BRACH_CD A1 12367 701 A2 6431 652 B5 7891 245   Staff: NAME ID BRANH_CD A1 12367 707 A2 6431 631 A3 7321 701 B1 3854...
    vivek pv
    last modified by vivek pv
  • Inner Join before Left Join?

    Currently, I am loading table one and then left joining table two to table one. Now what I need to do is load table one, load table two, inner join table two to a table three(which is a load of a subset of table two),...
    Dan Green
    last modified by Dan Green