Hi All,

autonumber with qlik partial load giving wrong results.

can you please suggest how to go ahead for the same.

is there any alternative functions that we can use for the partial load.

thanks

Hello All,

I have below 2 years of data in my Qlik :-

Date| LOB| Volumes

02/10/2022| SIP| 1000

..........

04/21/2020| ME| 2000

I am creating one view in front showcasing monthly , weekly , daily view  using below :-

Daily - Dimension - Date | measure - sum(Volumes)

Weekly - Dimension - Date_Saturday (we need to show saturday dates of each month) | Measure - Sum(Volume)

Monthly -Dimensoon - Date (Show last date of each month) | measure - sum({<isLastDayOfMonth={1}>}volume)

==============================================

-->For Showcasing saturday week , did this :-

if(weekday(Date)='Sat' ,Date) as Date_Saturday 

-->For Closing month Date of each month , did this -

If(floor(MonthEnd(Date))=Date,1,0) as isLastDayOfMonth,

=================================================

Now, I want to show in front tables as per below condition:-

1) Daily View - should show data for last 90 days in the table

2) Weekly view - should show the data for last 53 weeks in front table

Can anyone please tell me , how can I achieve this using set analysis ?

I have multiple dates in single table (like issue closed date, logged date) and I have to show the data in the same manner in different charts .

Thanks in advance

Hello

I´m trying to configure an advanced LDAP connection and I can´t get it working. And there is also no feedback. (no useful Log-files or whatsoever) Or am I missing something? In another post somebody mentioned this directory: C:\ProgramData\Qlik\Sense\Log\Scheduler
But as I said there is nothing helpful to find there.

When I have a look at the User directoy connectors page (https://localhost/qmc/userdirectoryconnectors) it says Configured: Yes, Operational: Yes, Status: Idle

When I start the Task it keeps failing whitout any useful information.

The reason why I want to use an advanced LDAP Connection is, that there is an option for additional LDAP fields you can import.

Many thanks in advance

Hi,

I want to merge 2 formulas into one in Qlikview expression.

Formula 1 : =Sum({$<Item_Type = {'N'} >}  [Total Sales])

Formula 2 : = Sum ({$<REFERENCE= p({1< [Product Code] = {'0000048565660'}>} REFERENCE) >} [Total Sales])

Thk very much.

Parakorn.T

Hi all,

I have scheduled a task and while executing its getting failed with the error message " \qvw\Admin\accesspoint failed : An untrusted certificate authority was detected while processing the smartcard certificate used for authentication."

Anyone knows how to resolve this?

Hi all,

is there any way to add labels to bar segments and marker points in qliksense combo chart ? If no, is there any free extension which provides that functionality ?

Thanks,

Aditya

hello friends, i m trying to do a dashboard where i can get sum of sales by yearMonth and last yearMonth

this screen can explain more my demand :

Hi Team, 

Kindly share the qvf file of Qliksense document analyzer if any one is having, we wanted the qvf file of QSDA. 


Thanks & Regards, 
A.Sreevalli.