Hi,

I have this script and it is not working.

tan:
LOAD * INLINE [
F1, F2
09/07/2021, ren
09/05/2021, rte
];

tan1:
load * Resident tan
Where F1 > date('09/06/2021', 'MM/DD/YYYY');

DROP TABLE tan;

I was expecting the table 'tan1' to have only the first row but tan1 is not even getting created.

what is wrong with it?

Thanks

Hi qlikss

i have 2 dates : date, business date

this is separate qvd with 2 dates   

date               business date

5/8/2021.      5/7/2021

5/18/2021.    5/18/2021

i have filter in my app that uses today’s date as overall filter on date field, but it has to pick up business date when todays date is not business date.  Suggest me.

in my app

Where date= date(today ());

Hi, 

I currently have an excel dataset and am trying to transpose the data as shown below but in Qlikview. Any ideas on how this can be achieved would be greatly appreciated!

Before:

After:

Many thanks

Dilpreet 

Hi all,

I have the following table of fields as an example:

I want to split Field_2  into subfields by values of Field_1, like:

The end user can select from the new fields one value (as an example: A1,B1,C1).

Field_2 should highlight A1,B1,C1 (should recognize the choosen values from its subfields).

The end user can select now one or more than value from A1,B1,C1 in field_2.

Any help please?

Thanks in advance.

I'm getting an invalid expression error in this section, but I'm very new to this and don't know what I'm doing wrong. Please advise!

Concatenate

LOAD DISTINCT
[!1],
SPCode,
PROD_CD_GRP AS RATE_SERIES_AC,
PLAN_CODE,
'XXXXXXXXXX' AS SORCE_POLCY_ID,
AS_OF_DATE,
WELLNESS_BENEFIT,
PLAN_TYPE,
PLAN_LEVEL,
COMPANY,
MARKET_SEGMENT,
SEX,
AVG(UNITS) AS UNITS,
RIDER AS COVG_IND,
'' as ISSUE_ST,
AGE_AT_ENTRY,
'$(vYear)' as ENTRY_YEAR,
1 as ENTRY_MONTH,
1 as ENTRY_DAY,
((avg(ANNUAL_PREM))/(avg(UNITS))) AS ANN_PREM_PU,
'XXXXXXXX' AS ORG_BCN,
'XXXXXXXX' AS CURR_BCN,
12 AS PREM_FREQ,
SUM(INIT_COV_COUNT) AS INIT_POLS_IF,
IF(FAMILY_CD='0','1',FAMILY_CD) AS FAMILY_TYPE,
5 AS GTEE_PER_Y,
ACC_EP,
SICK_EP,
100 AS COVERAGE_TERM_AGE,
(sum(WOP_BENFT_AMNT))/(sum(UNITS)) AS WOP_BENFT_AMNT_PU,
MAX(GAAP_LKUP_ALR_MORBD),
MAX(GAAP_LKUP_ALR_LAPSE),
MAX(GAAP_LKUP_ALR_MRTLY),
MAX(GAAP_LKUP_ALR_INT_RATE),
MAX(STAT_LKUP_ALR_MORBD),
MAX(STAT_LKUP_ALR_LAPSE),
IF(DEFAULT = 'Y', '190001', MAX(STAT_LKUP_ALR_MRTLY)) AS STAT_LKUP_ALR_MRTLY,
'' AS COHORT_CD,
'' AS INIT_DAC_EXPNS_VOL,
'' AS INIT_DAC_CMMSN_VOL
RESIDENT ACCIDENT_STAT_MORT1
WHERE (ISSDATE >= STAT_LKUP_ALR_MRTLY AND ISSDATE <= STAT_MAX_ALR_MRTLY) OR DEFAULT = 'Y'
ORDER BY SPCode;

Hello 

I learned by this forum that we could use 

-= to do an exclusion in set analysis but when i try to use it with a or to make 2/3 excluding that doesn't work 

if Someone could make me learn how to make work multiple excluding in set analysis ? 😛 

Thanks a lot for reading 😛

Hi there,

I am unable to border my excel report in nprinting edit report template.

req is below :

result:

I used the border when creating edit report template.

I am using master measures in Qlik Sense to create a bar chart and the master measure has a color applied. In Nprinting I am bringing this into a table object. The "Keep source format" is checked, however the color set in the Qlik Sense chart is not seen in the Nprinting chart. I want to be able to add expressions to set the color, as doing it manually is very cumbersome. If this is not possible, is there a syntax available to set the color when the "Keep source format" is unchecked?

Please let me know.