Hi Experts,

I'm doing cumulative sum - that is working fine, but if user select any product cumulative value should not be change.

below is my cumulative sum and I'm selecting one product as Tab, here cumulative sum has changed to 10.

Cumulative Sum: RangeSum(Above(TOTAL Sum(Sales), 0, RowNo(TOTAL)))

I did some work around when user select product, finding MIN and MAX value

like Min(Sales) and max({<Product=>}Sales)) - same way applied in set expression

=Sum({<Sales ={">=$(=min(Sales)) <=$(=max({<Product=>}Sales))"}, Product=>}total Sales) - this expression is working fine for one product selection.

but my problem is when user select multiple products not working.

my output should be:

if user select single product or Multiple products should not be change the cumulative value (If any sub filter selections cumulative should not change)

Thanks in Advance!

I have a field 'Lot '

in field  'Lot ' contains data :

I want to put 'A0' as the first two in this field.

example :

A0165052171

A0172050012

.

.

.

I have a field 'Lot '

in field  'Lot ' contains data :

want to add '-' to count the 6th data from the left.

EX

165052171

A0172050012

I created two space to offer an autoevaluation solution to a company:

- One space with a data entry saving Qvd within the space.

- One limited acces space for manager where a BI tool give them the opportunity to make data analysis.

I would like to automate two things:

1) when the qvd is stored (partial reload), i would like it to be moved automatically to the second space to be sure these data are made private.

2) Reload the BI tool to add load the new entries.

I can't figure how to move these qvd from one space to another with automation. Does anyone has completed such a task ?

Thanks in advance.

How can make a table like this?  The total is based on date + category but the date total is based only the date

I am using Qlik Sense EoW Aug 2022 Patch 3. I am getting unusual results when using an Outer Set Expression.

I am applying an Outer Set Expression to a master measure [Filled Positions]. When the value I use for the "Candidate Source" field does NOT exist anywhere in the data set for the app the expression for that field is ignored.

So this measure:

({<[Snapshot Year]={">=$(vPreviousYear_1)"},[Snapshot Month/Year]={"<=$(=Max([Snapshot Month/Year]))"},[Candidate Source]={'_UNKNOWN_'}>}[Filled Positions])

Returns the same value as this measure when "_UNKNOWN_" is NOT present in the data, but works correctly when "_UNKNOWN_" IS present in the data:

({<[Snapshot Year]={">=$(vPreviousYear_1)"},[Snapshot Month/Year]={"<=$(=Max([Snapshot Month/Year]))"}>}[Filled Positions])

If I create a new measure by copying my master measure [Filled Positions] and add the previous Outer Set Expression as an addition to the existing Inner Set Expression the result is correct, regardless of the presence of the "_UNKNOWN_" value in the data set.

Count(distinct{<[Table]={'Days to Fill'},[Max Emp Offer Date Flag]={'Y'},[Snapshot Year]={">=$(vPreviousYear_1)"},[Snapshot Month/Year]={"<=$(=Max([Snapshot Month/Year]))"},[Candidate Source]={'_UNKNOWN_'}>}[Job Req ID])

Is this a bug with my version? I did not read anything in the Qlik Help site related to Outer Set Expressions saying that a field would be ignored if the value was not part of the data set. Because I use Outer Set Expressions often now, it is very disturbing to think that they will work correctly most of the time, but if a value is dropped from the data set entirely, a previously working measure can return erroneous results.

Thanks

Hi Community,

I'm working on a tricky scenario.

Here it is.

I've below numbers:

LOAD * INLINE [

Number

62517

34

2174

];

Desired Output Required:

Number

12567

34

1247

If anyone has faced such issue then please share your suggestions.

Regards,
Eric

Hi! I am trying to create filtered views in a table, but can't figure out how to hide rows with measure having 0 or null value. I've tried disabling "Include 0 values" from data handling, and setting the output of this expression to display NUM values, but still not working. Expression below is calculating if date in Log for a record is within last day days. 

=IF((today(2)-daystart(max({<[Session Count] = {1}>} LogTimeStamp)))<90,NUM(today(2)-daystart(max({<[Session Count] = {1}>} LogTimeStamp))),NUM(0))

I Installed data movement on linux that Redhat8 of AWS EC2.

I’m trying connect to Oracle database with data integration. but when push test connect button then get about proxy error.

Checking the data movement log file,there is about proxy error following

[ERROR] Error connecting to Replicate server 'local_repsrv'
System.Net.WebException: The proxy tunnel request to proxy 'My proxy adress' failed with status code '307'."

Do you have any good solutions in regards to that?

best regard.