Dear Qlik community,

In a table, I have  2 dimensions, 'User ID' and 'Last login dt' (yyyy-mm-dd).

I want to create a 3rd dimension that has a list of 'UserID' whose 'last login dt' is more than 2 years ago.

I want to use set analysis to achieve this task.

thanks,

AS

Dear Team,

I want to upgrade my existing Qlik Sense version Sep 2020 13.95.3(Base Version)  and apply patch 9 of Sep 2020.

I have HA setup  comprising of one central node which has all services installed and one RIM node which has all  services installed except Repository database.

I just want to know when  i apply patch 9  of Sep 2020 will it have any impact to  Qlik root CA  certificate.

 I have to dead sure as i have to apply this to running production system and ensure nothing breaks.

Any advise/help  is much appreciated.

Regards

Arvind

Hi All,

I am pretty new to QlikView. I am trying to create linked objects.

I follow the Copy & Paste as a linked object procedure but when I try to open the object properties, Qlikview crashes and closes down.

Any suggestions?

Thank you in advance

carlo

Hi,

Someone helped me write this script, so it's a bit beyond my capabilities.  It is converting all income data whatever currency or distance measurement is used into USD and miles.  For some reason it is loading my data multiple times and I don't know why. 

conversionMap:
Mapping LOAD
AutoNumberHash128(Curnc_Year,Currency_Abbr,'currency') as ConversionKey,
USD_Equivalent
FROM [lib://Documents (1qconsulting_debi.cook)/Currency Conversion.xlsx]
(ooxml, embedded labels, table is Sheet1);

TempTable:
LOAD
YearID as TestYearID,
SubtextRow as Testsubtext,
[Year] as testyear,
if (SubtextRow = 'United Arab Emirates Dirham', 'AED', if(SubtextRow = 'Canadian Dollars', 'CAD')) as CurrencyAbbr
Resident [ResponseTable]
where match(SubtextRow, 'Canadian Dollars', 'United Arab Emirates Dirham')>0;

left Join ([ResponseTable])
Load
TestYearID as YearID,
testyear as Year,
CurrencyAbbr
resident TempTable;
drop table TempTable;

TempTable:
LOAD
YearID as TestYearID,
SubtextRow as Testsubtext,
[Year] as testyear,
if (SubtextRow = 'Kilometers','Kilometer') as DistKilometer
Resident [ResponseTable]
where match(SubtextRow,'Kilometers')>0;

left Join ([ResponseTable])
Load
TestYearID as YearID,
testyear as Year,
DistKilometer
resident TempTable;
drop table TempTable;

Data:
NoConcatenate Load
*,
if(Conversion = 'currency', Response / ApplyMap('conversionMap',AutoNumberHash128(num#(Year),CurrencyAbbr,Conversion),1),
if(Conversion = 'distance' and DistKilometer = 'Kilometer', Response/1.60934,
if(Conversion = 'sqmile' and DistKilometer = 'Kilometer', Response/1.60934*1.60934 ,
if(Conversion = 'acre' and DistKilometer = 'Kilometer', Response/.404686, Response) )))
as ConvertedResponse,
ApplyMap('conversionMap',AutoNumberHash128(num#(Year),CurrencyAbbr,Conversion),1) as USD_Equivalent
resident [ResponseTable];
drop table [ResponseTable];

drop field Response from Data;
rename field ConvertedResponse to Response;

Thanks

Hi guys,

is it possible to apply the same calculation condition to all the sheets of a Qw file setting it in one place instead of placing it in every chart?

(I'd like to avoid the calculation if no-selections are made, so that a computer freeze due to the large amount of data to be analyzed can't occurs).

Thank you so much.

N.

Hello Qlik Community Admin team,

I used to be able to post to "documents" thread under Sense and View, but I get a "permissions" error message whenever I try to create a new document now.

I contacted Mike Tarallo to ask for his advice and he has pointed me towards you. Could you please help me out with this?

Many thanks for your help in this matter.

Kind regards,

Cheenu