I need to calculate the average of a set of data at the latest recording date and then the last three recordings- can you help with the expressions?

Data looks like...  (excel copy attached)

and I would like to create

I have tried: 

Avg({$<[DATE IN]={'$(=Max[DATE IN])'}>} DLWG1)

Thanks

Hello Team,

I am using my shape file for Market territories to be shown on Map. Every Market territory is getting mapped on map. Now, i need to show territories only in the map. Territories are getting failed while showing them on map. Not sure why!

In the attached snapshot, you can see the 2 straight tables:

1: Dist_Code and Dist_Name are columns from Shape File.

2: Territory Code and Territory Name are columns from Client data. 

Does mismatch of Territory Code and DistCode is the reason for Territories not getting mapped?

Hello,

It's a really basic question and help request as it would probably need just a copy paste from an UK user 🙂 !

I'm having the french version of the formating:

SET ThousandSep=' ';
SET DecimalSep=',';
SET MoneyThousandSep=' ';
SET MoneyDecimalSep=',';
SET MoneyFormat='# ##0,00 €;-# ##0,00 €';
SET TimeFormat='hh:mm:ss';
SET DateFormat='DD/MM/YYYY';
SET TimestampFormat='DD/MM/YYYY hh:mm:ss[.fff]';
SET FirstWeekDay=0;
SET BrokenWeeks=0;
SET ReferenceDay=4;
SET FirstMonthOfYear=1;
SET CollationLocale='fr-FR';
SET CreateSearchIndexOnReload=1;
SET MonthNames='janv.;févr.;mars;avr.;mai;juin;juil.;août;sept.;oct.;nov.;déc.';
SET LongMonthNames='janvier;février;mars;avril;mai;juin;juillet;août;septembre;octobre;novembre;décembre';
SET DayNames='lun.;mar.;mer.;jeu.;ven.;sam.;dim.';
SET LongDayNames='lundi;mardi;mercredi;jeudi;vendredi;samedi;dimanche';
SET NumericalAbbreviation='3:k;6:M;9:G;12:T;15:P;18:E;21:Z;24:Y;-3:m;-6:μ;-9:n;-12:p;-15:f;-18:a;-21:z;-24:y';

And I would need it with the UK standard... (date in am/pm), GBP, standard UK formatting, etc... So if anyone have it, I would be really grateful !

Thanks by advance,

Best regards,

Antoine

Hi,

 I have Extension Qlik-Sense-D3-Visualization-Library-master. I downloaded from Qlik Brach. I added Qliksensed Desktop. 

I have file and loaded the data.

I am able to add only 3 Di mentions and 1 measures and chart type= Collapsible Dendrogam

But, when I tried to add 4th dimention the extension throwing error like below and since I am not JS developer. Not able to understand  what is the issue

I attached extension as well and please check and let me know

Error: Invalid value for <g> attribute transform="translate(NaN,undefined)"ta.transform @ d3.min.js:4
d3.min.js:5 Error: Invalid value for <path> attribute d="M0,359.03108992CNaN,0.803340288 NaN, NaN,"(anonymous function) @ d3.min.js:5

Hi,

I'm trying to create a chart that has -

1. Top 50% of countries
2. + Australia

The following works when there is no selection

=Aggr( DISTINCT
  	If( RangeSum( Above(Sum({$<RecType={2}, CountryFlag={1}, UoM={'MT'}>} Quantity), 1, RowNo() ))
               	      / Sum({$<RecType={2}, CountryFlag={1}, UoM={'MT'}>} TOTAL Quantity) < 0.5
	OR Country='Australia'
      ,Country )
//    sorted structure parameter
      ,(Country,(=Sum({$<RecType={2}, CountryFlag={1}, UoM={'MT'}>} Quantity),Desc))
    )

but when I select 'Europe' I only get Russia & Germany which is correct for the 50% part, but can't add Australia. (i.e. I want Australia regardless of where it comes in the rankings) I tried using a reference line but that didn't work either.

Any ideas would be appreciated.

I am trying to load data from a xml file to make a table but i also want to display the data types of the values present in my table. is there any way to do it ?

I want to create a bar chart that would show me recent last 5 weeks data by default. And then when user selects any date
then based on the selection it would show that week and previous 4 weeks 0f data in the same fashion.
So in my load script , i have this code for dates.

DATE,
WeekDay(DATE) as D_WEEKDAY,
Year (DATE) as D_YEAR,
Month (DATE) as D_MONTH,
Year(DATE) * 12 + num(Month(DATE)) as [MonthCounter],
Date(MonthStart(DATE),'MMM-YYYY') as MonthYear,
Day (DATE) as D_Day,
week(DATE) as D_Week,
AutoNumber(Year(DATE) & Week(DATE)) AS WeekSerial

Then in the chart expression i am using the following code to show 5 recent weeks,

=FABS(sum({<WeekSerial={"<=$(=(max(WeekSerial)))>=$(=(max(WeekSerial)-4))"},D_MONTH,D_YEAR>} Sales))

The above approach is not working when i click on the date filer, then it is only showing me that week data .
I need to show that week and 4 previous weeks as well (total 5 weeks).

Please advise.

Hi
we are using NPrinting 16.

I have setup a "Import Recipient Task" which works fine.

What I want to do now is to import only a filtered subset of recipients from the QlikView document.
But there is no "filter" option for an Import Task.

Is it possible to apply a filter to the qlikview document when opening it with NPrinting, in order to
limit the import?

What I could possibly do is to create a "Run Macro Task" and then execute the macro (applying a bookmark) before execution of the recipient import. Is there another way to do it (as I do not like macros)?

Thank you!

Marcel

Hi All,

My calculation below needs a last level of refining. I have an overall aggregation on Client, Member and Investment Product level. (Green)

Then within the calculation I need the result to be zero when the sum of the indicator column is greater than or equal to 1 at a Client, Member level. (Blue)

I think I understand why it is still not working because of my overall AGGR being at a lower level. 

Is there another way around this?

Many thanks,

James

sum(AGGR(

{<  dteTerminationDate4INDICATOR = {'-1'}, dteTerminationDate3INDICATOR = {'-1'},  dteDJFNew = {[<=$(vEndDate)]}, fkiLedgerID = {'1010','1020'}, fkiDescriptionID = {">3"},fkiInvestmentPolicyINDICATOR = {'-1'} >    }

if(  aggr(sum( {dteEffectiveDate14={[<=$(vEndDate)]}}blnBankAccn),ClientID,MemberID)   >= 1  , 0,

sum ( {< dteEffectiveDate14 = {"<=$(vEndDate)"} >} numProductUnits14 ) * FirstSortedValue( {< dteDate16 = {"<=$(vEndDate)"} >}  numOfferPrice , - dteDate16 ) )

,ClientID, MemberID,InvestmentProductID         

))

Hi,

I was checking a thread https://community.qlik.com/t5/Qlik-Education-Discussions/Calculate-Column/m-p/1584234#M3813, I could not understand what the user wanted , nevertheless i thought to convert the table onto cross table using generic load but post the join i do not seem to get the matching records from table 2 and table 3 , it seems to join only table 1 not sure what is going wrong.

Could someone please check what i have missed in here

Attached is the Qliksense Document that I have been working on