Hola  a todos!!

Quiero realizar un filtro acumulado de tal forma que, al seleccionar un dia de un mes y año determinado, la información que entregue el dash sean desde el 01/01   hasta esa fecha. por ejemplo, si selecciono 06/01 en el filtro, los resultados que entregue un gráfico de barras serán los valores acumulados de las fechas  01/01, 02/03, 04/01, 05/01, 06/01. 

¿Existe alguna opción por defecto? ¿Alguna extensión que me pueda ayudar? ¿set análisis? ya intente RangeSum(Above(sum(TOTAL),0,RowNo())) y no me sirve (al seleccionar una fecha, me da el valor asociado a ese día en particular y no el acumulado)

 Gracias!!!!

Hello everyone !

 I want created a acumulated sum by date. for example, if select one date (06/01), the result in the screen is the sum acumulated of  01/01, 02/03, 04/01, 05/01, 06/01. 

exist a option by default ? extension? set analist? i try with RangeSum(Above(sum(TOTAL),0,RowNo()))  but It's not what I need.

Thanks!!!!

Hi All,

I am trying to connect to sharepoint site using web connector.  But I am getting below error when authenticating the site:

There was a problem authenticating with the connector, further information is listed below:

error = invalid_request
error_description = AADSTS90027: We are unable to issue tokens from this API version on the MSA tenant. Please contact the application vendor as they need to use version 2.0 of the protocol to support this.
Trace ID: 910ab797-d7a2-4a96-8cb7-f6e010909100
Correlation ID: 78b6f0aa-164e-419d-b116-b58ab9b9711d
Timestamp: 2021-07-23 22:27:00Z

Any idea what this means?

Thank you!

Hello,

Interested in some guidance for a user considering moving from a cube reporting tool to qlk sense.

In the cube reporting tool they can dynamically build their own reports using pre-defined Dimensions and Measures and then export to excel.

Thank You,

Michael

We have upgraded from Qlikview Server April 2019 SR4 to Qlikview May 2021 (12.60).  The PDF-Xchange printer driver is no longer installed with Qlikview 12.60. The printer Qlikview now uses is 'Microsoft Print to PDF'.

After the upgrade Qlikview Reports (RP objects)  that print to PDF are either 20 times the size of the files that used to get generated by the PDF-Xchange printer, or the PDF files are corrupted and you can't even open them.  This occurs in Server and Desktop.

However, if you choose the PDF-Exchange printer in Desktop the reports are produced as they were - just fine.  It appears that there is no way of changing the printer to 'PDF-Xchange' in Qlikview Server. I have changed the printer in Publisher to 'PDF-Exchange' but that does not seem to feed through to Qlikview Server in Access Point.

Any assistance, or fixes, would be appreciated.

Hi,

I want to count how many visits took place between 07:00 - 15:00 

I have been using the following expression :

=Count({$<Time={">=07:00<=15:00)"}>} Visit)

but it keeps coming up with all the visit and not just between 07:00-15:00

Thanks,

Sharbel

l would like to generate dates between two dates . That is, [Start Date] and [End Date]. But when I run the code below it runs with out end. Below is the code. I would like to know what am doing wrong. Thanks for your suggestions

[HR Status DatesTmp]:
Load *,
Date([Start Date] + IterNo() - 1 ) as [Status Date]
Resident [Applicant]
While IterNo() <= Date([Start Date]) - Date([End Date]) + 1 ;

Hello all,

i want to use the datepicker, but nothing is appearing as datefield. 

start and endate are saved like this in the database: 2021-07-13 11:03:58

I'm loading my data like this in Qlik: 

LOAD id,
username,
Date(enddate) as EndDate,
Date(startdate) As StartData,
interval(enddate-startdate) as Duration;

[runs]:
SELECT id,
startdate,
enddate,
username,
FROM `database`.runs;

Unfortunately there is no value to select in the datepicker. i guess the startdate and endate are not recognized as date.

Can someone help me?

Hello there!

I am using the following expression as a measure while designing a bar graph.

The result is as expected but the visualization is taking some time to load up on selections(understandable as there are many conditions in the expression). Is there any other simple/effective way to achieve this so that the performance wouldn't be low.

My expression:

if(getselectedcount([School Year])=0 and valuelist('At-Risk','CFSA','English Learner','Homeless','Migrant Status','Military Connected','Students with Disabilities'
,'Gender(Male)','Gender(Female)','Gender(Non-binary)')
='Students with Disabilities',
if(Count({<[Type]={'Current'},[School Year]={'2020-2021'},[SWD Status]={'YES'}>} distinct USI)
/Count({<[Type]={'Current'},[School Year]={'2020-2021'}>} distinct USI)<0.001,'<0.1%',
Count({<[Type]={'Current'},[School Year]={'2020-2021'},[SWD Status]={'YES'}>} distinct USI)
/Count({<[Type]={'Current'},[School Year]={'2020-2021'}>} distinct USI)),

if(getselectedcount([School Year])=0 and valuelist('At-Risk','CFSA','English Learner','Homeless','Migrant Status','Military Connected','Students with Disabilities'
,'Gender(Male)','Gender(Female)','Gender(Non-binary)')
='At-Risk',
if(Count({<[Type]={'Current'},[School Year]={'2020-2021'},[At-Risk]={'YES'}>} distinct USI)
/Count({<[Type]={'Current'},[School Year]={'2020-2021'}>} distinct USI)<0.001,'<0.1%',
Count({<[Type]={'Current'},[School Year]={'2020-2021'},[At-Risk]={'YES'}>} distinct USI)
/Count({<[Type]={'Current'},[School Year]={'2020-2021'}>} distinct USI)),

if(getselectedcount([School Year])=0 and valuelist('At-Risk','CFSA','English Learner','Homeless','Migrant Status','Military Connected','Students with Disabilities'
,'Gender(Male)','Gender(Female)','Gender(Non-binary)')
='English Learner',
if(Count({<[Type]={'Current'},[School Year]={'2020-2021'},[English Learner Status]={'YES'}>} distinct USI)
/Count({<[Type]={'Current'},[School Year]={'2020-2021'}>} distinct USI)<0.001,'<0.1%',
Count({<[Type]={'Current'},[School Year]={'2020-2021'},[English Learner Status]={'YES'}>} distinct USI)
/Count({<[Type]={'Current'},[School Year]={'2020-2021'}>} distinct USI)),

if(getselectedcount([School Year])=0 and valuelist('At-Risk','CFSA','English Learner','Homeless','Migrant Status','Military Connected','Students with Disabilities'
,'Gender(Male)','Gender(Female)','Gender(Non-binary)')
='CFSA',
if(Count({<[Type]={'Current'},[School Year]={'2020-2021'},CFSA={'YES'}>} distinct USI)
/Count({<[Type]={'Current'},[School Year]={'2020-2021'}>} distinct USI)<0.001,'<0.1%',
Count({<[Type]={'Current'},[School Year]={'2020-2021'},CFSA={'YES'}>} distinct USI)
/Count({<[Type]={'Current'},[School Year]={'2020-2021'}>} distinct USI)),

if(getselectedcount([School Year])=0 and valuelist('At-Risk','CFSA','English Learner','Homeless','Migrant Status','Military Connected','Students with Disabilities'
,'Gender(Male)','Gender(Female)','Gender(Non-binary)')
='Homeless',
if(Count({<[Type]={'Current'},[School Year]={'2020-2021'},[Homeless Status]={'YES'}>} distinct USI)
/Count({<[Type]={'Current'},[School Year]={'2020-2021'}>} distinct USI)<0.001,'<0.1%',
Count({<[Type]={'Current'},[School Year]={'2020-2021'},[Homeless Status]={'YES'}>} distinct USI)
/Count({<[Type]={'Current'},[School Year]={'2020-2021'}>} distinct USI)),

if(getselectedcount([School Year])=0 and valuelist('At-Risk','CFSA','English Learner','Homeless','Migrant Status','Military Connected','Students with Disabilities'
,'Gender(Male)','Gender(Female)','Gender(Non-binary)')
='Military Connected',
if(Count({<[Type]={'Current'},[School Year]={'2020-2021'},[Military Connected Status]={'YES'}>} distinct USI)
/Count({<[Type]={'Current'},[School Year]={'2020-2021'}>} distinct USI)<0.001,'<0.1%',
Count({<[Type]={'Current'},[School Year]={'2020-2021'},[Military Connected Status]={'YES'}>} distinct USI)
/Count({<[Type]={'Current'},[School Year]={'2020-2021'}>} distinct USI)),

if(getselectedcount([School Year])=0 and valuelist('At-Risk','CFSA','English Learner','Homeless','Migrant Status','Military Connected','Students with Disabilities'
,'Gender(Male)','Gender(Female)','Gender(Non-binary)')
='Migrant Status',
if(Count({<[Type]={'Current'},[School Year]={'2020-2021'},[Migrant Status]={'YES'}>} distinct USI)
/Count({<[Type]={'Current'},[School Year]={'2020-2021'}>} distinct USI)<0.001,'<0.1%',
Count({<[Type]={'Current'},[School Year]={'2020-2021'},[Migrant Status]={'YES'}>} distinct USI)
/Count({<[Type]={'Current'},[School Year]={'2020-2021'}>} distinct USI)),

if(getselectedcount([School Year])=0 and valuelist('At-Risk','CFSA','English Learner','Homeless','Migrant Status','Military Connected','Students with Disabilities'
,'Gender(Male)','Gender(Female)','Gender(Non-binary)')
='Gender(Male)',
if(Count({<[Type]={'Current'},[School Year]={'2020-2021'},Gender={'Male'}>} distinct USI)
/Count({<[Type]={'Current'},[School Year]={'2020-2021'}>} distinct USI)<0.001,'<0.1%',
Count({<[Type]={'Current'},[School Year]={'2020-2021'},Gender={'Male'}>} distinct USI)
/Count({<[Type]={'Current'},[School Year]={'2020-2021'}>} distinct USI)),

if(getselectedcount([School Year])=0 and valuelist('At-Risk','CFSA','English Learner','Homeless','Migrant Status','Military Connected','Students with Disabilities'
,'Gender(Male)','Gender(Female)','Gender(Non-binary)')
='Gender(Female)',
if(Count({<[Type]={'Current'},[School Year]={'2020-2021'},Gender={'Female'}>} distinct USI)
/Count({<[Type]={'Current'},[School Year]={'2020-2021'}>} distinct USI)<0.001,'<0.1%',
Count({<[Type]={'Current'},[School Year]={'2020-2021'},Gender={'Female'}>} distinct USI)
/Count({<[Type]={'Current'},[School Year]={'2020-2021'}>} distinct USI)),

if(getselectedcount([School Year])=0 and valuelist('At-Risk','CFSA','English Learner','Homeless','Migrant Status','Military Connected','Students with Disabilities'
,'Gender(Male)','Gender(Female)','Gender(Non-binary)')
='Gender(Non-binary)',
if(Count({<[Type]={'Current'},[School Year]={'2020-2021'},Gender={'Non-binary'}>} distinct USI)
/Count({<[Type]={'Current'},[School Year]={'2020-2021'}>} distinct USI)<0.001,'<0.1%',
Count({<[Type]={'Current'},[School Year]={'2020-2021'},Gender={'Non-binary'}>} distinct USI)
/Count({<[Type]={'Current'},[School Year]={'2020-2021'}>} distinct USI)),

if(getselectedcount([School Year])<>0 and valuelist('At-Risk','CFSA','English Learner','Homeless','Migrant Status','Military Connected','Students with Disabilities'
,'Gender(Male)','Gender(Female)','Gender(Non-binary)')
='Students with Disabilities',
if(Count({<[Type]={'Current'},[SWD Status]={'YES'}>} distinct USI)
/Count({<[Type]={'Current'}>} distinct USI)<0.001,'<0.1%',
Count({<[Type]={'Current'},[SWD Status]={'YES'}>} distinct USI)
/Count({<[Type]={'Current'}>} distinct USI)),
if(getselectedcount([School Year])<>0 and valuelist('At-Risk','CFSA','English Learner','Homeless','Migrant Status','Military Connected','Students with Disabilities'
,'Gender(Male)','Gender(Female)','Gender(Non-binary)')
='At-Risk',
if(Count({<[Type]={'Current'},[At-Risk]={'YES'}>} distinct USI)
/Count({<[Type]={'Current'}>} distinct USI)<0.001,'<0.1%',
Count({<[Type]={'Current'},[At-Risk]={'YES'}>} distinct USI)
/Count({<[Type]={'Current'}>} distinct USI)),
if(getselectedcount([School Year])<>0 and valuelist('At-Risk','CFSA','English Learner','Homeless','Migrant Status','Military Connected','Students with Disabilities'
,'Gender(Male)','Gender(Female)','Gender(Non-binary)')
='English Learner',
if(Count({<[Type]={'Current'},[English Learner Status]={'YES'}>} distinct USI)
/Count({<[Type]={'Current'}>} distinct USI)<0.001,'<0.1%',
Count({<[Type]={'Current'},[English Learner Status]={'YES'}>} distinct USI)
/Count({<[Type]={'Current'}>} distinct USI)),
if(getselectedcount([School Year])<>0 and valuelist('At-Risk','CFSA','English Learner','Homeless','Migrant Status','Military Connected','Students with Disabilities'
,'Gender(Male)','Gender(Female)','Gender(Non-binary)')
='CFSA',
if(Count({<[Type]={'Current'},[CFSA]={'YES'}>} distinct USI)
/Count({<[Type]={'Current'}>} distinct USI)<0.001,'<0.1%',
Count({<[Type]={'Current'},[CFSA]={'YES'}>} distinct USI)
/Count({<[Type]={'Current'}>} distinct USI)),
if(getselectedcount([School Year])<>0 and valuelist('At-Risk','CFSA','English Learner','Homeless','Migrant Status','Military Connected','Students with Disabilities'
,'Gender(Male)','Gender(Female)','Gender(Non-binary)')
='Homeless',
if(Count({<[Type]={'Current'},[Homeless Status]={'YES'}>} distinct USI)
/Count({<[Type]={'Current'}>} distinct USI)<0.001,'<0.1%',
Count({<[Type]={'Current'},[Homeless Status]={'YES'}>} distinct USI)
/Count({<[Type]={'Current'}>} distinct USI)),
if(getselectedcount([School Year])<>0 and valuelist('At-Risk','CFSA','English Learner','Homeless','Migrant Status','Military Connected','Students with Disabilities'
,'Gender(Male)','Gender(Female)','Gender(Non-binary)')
='Military Connected',
if(Count({<[Type]={'Current'},[Military Connected Status]={'YES'}>} distinct USI)
/Count({<[Type]={'Current'}>} distinct USI)<0.001,'<0.1%',
Count({<[Type]={'Current'},[Military Connected Status]={'YES'}>} distinct USI)
/Count({<[Type]={'Current'}>} distinct USI)),
if(getselectedcount([School Year])<>0 and valuelist('At-Risk','CFSA','English Learner','Homeless','Migrant Status','Military Connected','Students with Disabilities'
,'Gender(Male)','Gender(Female)','Gender(Non-binary)')
='Migrant Status',
if(Count({<[Type]={'Current'},[Migrant Status]={'YES'}>} distinct USI)
/Count({<[Type]={'Current'}>} distinct USI)<0.001,'<0.1%',
Count({<[Type]={'Current'},[Migrant Status]={'YES'}>} distinct USI)
/Count({<[Type]={'Current'}>} distinct USI)),
if(getselectedcount([School Year])<>0 and valuelist('At-Risk','CFSA','English Learner','Homeless','Migrant Status','Military Connected','Students with Disabilities'
,'Gender(Male)','Gender(Female)','Gender(Non-binary)')
='Gender(Male)',
if(Count({<[Type]={'Current'},Gender={'Male'}>} distinct USI)
/Count({<[Type]={'Current'}>} distinct USI)<0.001,'<0.1%',
Count({<[Type]={'Current'},Gender={'Male'}>} distinct USI)
/Count({<[Type]={'Current'}>} distinct USI)),
if(getselectedcount([School Year])<>0 and valuelist('At-Risk','CFSA','English Learner','Homeless','Migrant Status','Military Connected','Students with Disabilities'
,'Gender(Male)','Gender(Female)','Gender(Non-binary)')
='Gender(Female)',
if(Count({<[Type]={'Current'},Gender={'Female'}>} distinct USI)
/Count({<[Type]={'Current'}>} distinct USI)<0.001,'<0.1%',
Count({<[Type]={'Current'},Gender={'Female'}>} distinct USI)
/Count({<[Type]={'Current'}>} distinct USI)),
if(getselectedcount([School Year])<>0 and valuelist('At-Risk','CFSA','English Learner','Homeless','Migrant Status','Military Connected','Students with Disabilities'
,'Gender(Male)','Gender(Female)','Gender(Non-binary)')
='Gender(Non-binary)',
if(Count({<[Type]={'Current'},Gender={'Non-binary'}>} distinct USI)
/Count({<[Type]={'Current'}>} distinct USI)<0.001,'<0.1%',
Count({<[Type]={'Current'},Gender={'Non-binary'}>} distinct USI)
/Count({<[Type]={'Current'}>} distinct USI))

))))))))))
))))))))))

Thanks,

Sai.