Welcome to Qlik Community

Hi,

Let's imagine this table:

measures are: sum(sales) and  count(distinct{<[type]={'sale'}>} name&surname)

If we apply filter 'refund' in dimension 'type', table transforms to this:

Is it possible to achieve this table (keeping  count distinct type='sale' calculation, but not showing 'sale' type rows in table, using some kind of set analysis?

LOAD * Inline [
name,surname,type,sales
john,smith,refund,-50
mary,bryant,refund,-100
arthur,jones,sale,150
brenda,patrick,sale,75
lisa,jackson,sale,50
];

Thanks in advance, 

Jose

I need to get the minimum value from column F by excluding the values of column F where column E is empty

please tell me how to do this using set analysis

I want to use the AddYears function in a dimension (column of a table), but not with a static n-value that indicate the years to add or subtract.

One of the Columns indicate the Depreciation Year. In order to indicate the depreciation years I had to do the following: AGGR(ONLY ({<[Attribute Code]={'DEPRECIATION YEARS'}>} [Attribute Value]),[Asset Code]))  this provides a number, e.g. 4

I now what to use that value in another column to indicate the Remaining Depreciation Year. I wanted to do the following: AddYears([Commissioned On Date] , AGGR(ONLY ({<[Attribute Code]={'DEPRECIATION YEARS'}>} [Attribute Value]),[Asset Code])) . This does however not work. 

When I do the following:  AddYears([Commissioned On Date] , 4) I get the answer I am looking for, but the n-value of the AddYears value will be dynamic for each Asset that is in the table.

Thanks is advance

Marisa

Hello all,

I am hoping someone can point out what I am clearly missing with load script.

I am the following which creates a master linked table.

Let vAssociationTableName = 'AssociationTable';

$(vAssociationTableName):
LOAD * INLINE [
_FactCounter
1
] WHERE 1 = 0;

LET vNoOfTables = NoOfTables();
FOR vTableNumber = 0 to ($(vNoOfTables) -1)
LET vTableName = TableName($(vTableNumber));
LET vTempTableName = '$(vTableName)';
IF Right('$(vTableName)',7) = '_NOLOAD' THEN
LET vTempTableName = Left('$(vTableName)',(Len('$(vTableName)')-7));
END IF
LET vFactFieldName = '_Fact_' & '$(vTempTableName)' & 'Key';
IF FieldNumber('$(vFactFieldName)','$(vTableName)') > 0 THEN
LET vLoadString = 'CONCATENATE (' & '$(vAssociationTableName)' & ') ' & Chr(13) & Chr(10) & 'LOAD DISTINCT ' & '$(vFactFieldName)' & Chr(13) & Chr(10);
LET vNoOfFields = NoOfFields('$(vTableName)');
FOR vFieldNumber = 1 to $(vNoOfFields)
LET vFieldName = FieldName($(vFieldNumber), '$(vTableName)');
IF Left('$(vFieldName)',1) = '_' AND Right('$(vFieldName)',2) = 'ID' AND Left('$(vFieldName)',6) <> '_Fact_' THEN
LET vStringStart = Index('$(vFieldName)','_',-1);
LET vStringEnd = (Len('$(vFieldName)') - 2);
LET vStringLen = $(vStringEnd) - $(vStringStart);
LET vThisField = Mid('$(vFieldName)', ($(vStringStart)+1), $(vStringLen));
LET vThisFactField = '_Fact_' & '$(vThisField)' & 'Key';
IF '$(vThisFactField)' <> '$(vFactFieldName)' AND ISNULL(TableNumber('$(vThisField)')) = 0 THEN
LET vLoadString = '$(vLoadString)' & ',' & '$(vFieldName)' & ' AS ' & '$(vThisFactField)' & Chr(13) & Chr(10);
END IF
END IF
NEXT ;
LET vLoadString = '$(vLoadString)' & ', ' & 'TableName($(vTableNumber))' & ' AS _FactType' & Chr(13) & Chr(10);
LET vLoadString = '$(vLoadString)' & ',1 AS _FactCounter' & Chr(13) & Chr(10);
LET vLoadString = '$(vLoadString)' & 'RESIDENT ' & '$(vTableName)' & ';' ;
$(vLoadString)
End If
NEXT ;

The script is adding pink highlight to the last "End if" as seen below, but I can not figure out why. I should also add that it runs fine and does what I am aiming to do.

What are your thoughts?

Thank you in advance.

Hi,

I got a requirement to develope a helpdesk dashboard. One of requirement for the dashboard is to link text box and show the data based on filter in table. I've been looking for the solution but still can't get it. 

Example as per below: 

If I click on view details text, then the detail list of high priority data will be display in table in other sheet.

https://demos.qlik.com/qlikview/HelpdeskManagementQV?q=helpdesk

Any solution to do that? 

Thank you for your help. 

Hi, 

I have a line chart which uses 2 x Dimensions (1 x Group and 1 x Line).

However, I only have the option to include one measure. Is there anyway of adding in another measure without it being an alternative view please?

Hi QV Experts, my first post and new to QV scripting. I am trying to load the below sample data with the "month-year" under Header 5 (as Month), every line to repeat (Sep-19) but unsure how to script this in the code. 

Loading the headers and the data content is easy. 

I have multiple tables/files to load across in the same format too. 

Appreciate the help! Cheers 

Hi Friends,

I have installed R in my qliksense desktop(April 2020 release) following all the steps mentioned in the attached document. and also downloaded the sample app Airline Passengers and Iris species app but I am not able to see the chart in these app. It is giving an error message 'Client specified an invalid argument'. Did anybody face the same issue? Could somebody please suggest if I need to redo the installation process ?Where am I getting wrong?

Thanks 

Shilpa