I am attempting to calculate the Sum of a group of receipts for multiple markets. However there are 2 markets in which I need the Sum cut in half.

I have tried several nested IF statements so that those 2 are always cut in half, and the sum of all are brought in but have yet to figure it out.

Any ideas?

hi,

im pulling in multiple csvs into one qvd. however i want the script to only read in new csvs and store it into the existing qvd, i dont want it to reread every csv file every time as it will be quite slow due to large amount of csvs.

im having a few problems,

firstly when it runs it doesn't update the qvd if i put a new csv in a folder, 

second, i want to be able to identify a specific string in all the files, but i only know how to do it for each field, is it possible to search the entire file instead of a specific field?

my code:

SUB DoDir(Root)

FOR each File in filelist( Root & '\*.csv')

test:
LOAD *, RowNo() as rows, filename() as filename,
if(wildmatch([Sector 27],'*¡MM')=1, [Sector 27]) as Sector27MM_Fails,
if(wildmatch([Sector 27],'*¡MM*')+wildmatch([Sector 27],'*¡NR*')+
wildmatch([Sector 27],'*¡WL*')+ wildmatch([Sector 27],'*¡BG*')+ wildmatch([Sector 27],'*¡FG*')=1, [Sector 27]) as Sector27AllFails

FROM
[$(File)]
(txt, codepage is 28591, embedded labels, delimiter is ',', header is 1 lines);
STORE test INTO [lib://........completeQvd.qvd] (qvd);

NEXT File

FOR each Dir in Dirlist (Root&'\*')

CALL DoDir(Dir)

NEXT Dir

END SUB

CALL DoDir('[lib://..../LVS')

Hi there,

Please kindly help me out in the expression -

I want until the first word after comma .

My requirement is  to show  in else statement -

COLLINS, KYM

ALLEN, CHRISTOPHER

ADAM, JOHN

expression I tried -

Hello,

If I have my raw data on a separate server running linux (with different time settings) and the processed QVD files on a windows machine, from which server does the script log (app task execution) get its timestamp from? Will it be from the original linux server where it gets the raw data or from the windows machine where it saves the processed qvd files at?

Hi All,

I am trying to write a expression like below but this is not giving me any output even there is not error in the expression 

Can someone please correct me  on this 

Expression :

=if(Floor(DelDate)=Floor(ColectDate),
count({<Status={'Closed'},
Sales={'Ach'}>}ID))

Thanks in Advance 

Dear all,

I'm new to Qlik sense and facing an issue with a specific table I try to load.

Indeed I have two tables (= see example below) :

[COST CENTER]:

In this first table, I find all cost centers and the budget owner ID associated for each of them.

For some cost center there is no budget owner determined. The field Budget owner ID stay blank.

[USER ID]

In a second table, I have a list of User ID.

I want to display the first table by removing the line on which I can find a User ID part of [User ID] table.

I want also to keep the line on which there is no budget owner ID determined.

So, if we keep example below, at the end I want a table loaded like below:

[COST CENTER}:

Indeed, 

0124528Z is part of [User ID] table so I want the line removed

0147889A is part of [User ID] table so I want the line removed

7305485 is not part of  [User ID] table so I want to keep and display the line

For the cost center 2028, there is no Budget owner ID so I want to keep the line.

At the end, there is only the two lines above displayed.

How in data load editor, I can handle this?

Looking forward to an answer.

Best regards

David

We are pleased to share that the Qlik Enterprise Manager November 2021 initial release is now available.   

This release includes a number of enhancements, including support for all Replicate notifications within Enterprise Manager, allowing you to manage all of the notifications related to your Replicate servers and replication tasks in a single location.

More information about the release can be found on our product innovation blog.   

Hi there,

Please kindly assist me with the expression-

below expression is helping me to get the [GP Full Name] which is not "GP, NO GP","GP, NOT KNOWN","GP, NOT LISTED","GP, NOT STATED","GP, NOT FOUND","GP, NO CONSENT" .

=Aggr(Only({<[GP Full Name] -= {"GP, NO GP","GP, NOT KNOWN","GP, NOT LISTED","GP, NOT STATED","GP, NOT FOUND","GP, NO CONSENT"}>} [GP Full Name]), [GP Full Name])

with the above expression -partly working 

But I want to add in the condition [GP Full Name]  like "%PRACTICE%","%MEDICAL%","%CENTRE%" should also not show i.e come NULL else show [GP Full Name]

I want to add the condition so that the below should also not show up

Trying something like below but not working

=Aggr(Only({<[GP Full Name] -=like {"GP, NO GP","GP, NOT KNOWN","GP, NOT LISTED","GP, NOT STATED","GP, NOT FOUND","GP, NO CONSENT","%PRACTICE%","%MEDICAL%","%CENTRE%"}>} [GP Full Name]), [GP Full Name])

Thanks

Hi All!

I'm setting up an email report and I want to setup a default selection where users can only view the data from the past 30 days.  I'm using a bookmark to make this the default selection when people are viewing the dashboard, so I'm wondering if there is a way to apply this bookmark to the automation that I'm creating to send out the email report.

Thanks,

Sam

Hello!

I'm having trouble with this table:

I used the following formula so in the first column, the numbers underlined in red calculate the average of the numbers to their right instead of showing the sum, and the totals of every column show the sum of their numbers below:

if(Dimensionality()=0,
sum((calificacionM/100)*porcentaje),
avg(aggr(sum((calificacionM/100)*porcentaje), [MESAÑO_CON], nombreClasificaciones, num_porcentaje)))

What I'm having trouble with is that I need the number highlighted in yellow to sum the numbers below, not the numbers to its right, so I can have 96.75 instead of 967.48.

Any ideas? Is it possible? Thanks so much for your help!!