Hello! 

I need to create a filter in the set analyses which sums only the records where the #eventDate is in the first 8 days after the #installDate. Both dates are stored as numbers (eg: 47823)

The below formula works fine when the two dimensions are selected in the table, however since this is a dynamic visualization, i need to incorporate the if statement in the Set analysis so it always filters the results regardless of the selected dimensions in the table.

if(eventDate <= date([installDate.date.Date] +7), Aggr($(vL.exp.KPIs.Period(Sum,$(=Only({<#meCode={"msr46"}>} [#kpi_id])),appstore*,appstore*, )), $(vL.selected.Dimensions.field)), 0)

I have tried numerous options in the set analyses however nothing seems to work. 

Ex: 

$(vL.exp.KPIs.Period(Sum,$(=Only({<#meCode={"msr46"}>} [#kpi_id])),appstore*,appstore*,, eventDate,<=[installDate.date.Date]+7)) 

The formula for vL.exp.KPIs.Period is:
$1({<KPI={"$2"},Source={"$3"} $(vL.time.Period), [$6]*={"$7"}, [$8]*={"$9"}>} $5 (KPI.Multiplier/KPI.Denominator)*value*Nume_multiplier)/If($1({<KPI={"$2"}, Source={"$4"} $(vL.time.Period), [$6]*={"$7"}, [$8]*={"$9"}>} $5 value*Denome_multiplier)=0,1,$1({<KPI={"$2"}, Source={"$4"} $(vL.time.Period), [$6]*={"$7"}, [$8]*={"$9"}>} $5 value*Denome_multiplier))

Any ideas will be appreciated!

Hi All,

I have attached a sample dataset (Ledger Account), in which I have highlighted a column in yellow, which is the column to be achieved in Qlik Sense.

Can anyone refer to that, give me a solution. I have attached below a screenshot also.

What Should Happen -> In the balance column, we have the amount of each document value, In a new column, first line should show (Closing balance of 2023-balance column first line doc value), and in second line it should show, (new column first line value-balance column second line doc value), and it should till last row.

Note: - This is only one ledger account dataset, there are multiple ledges.

Hi All,

I have created a default bookmark selections for all sheets. I'm selecting few extra selection in a sheet with default bookmark and switching to another sheets. Post switching to another sheet i'm only able to see the default bookmark not the extra selections with it.

I want to carry the extra selections with default bookmark when i switching the sheets within the application.

Thank you in advance!

Daya

I have a variable set as vCurrentMonth showing 19 which is the Date.Chron.Month value. 

I would like a textbox to display the value for Date.Month.Year (May-2024) through using the vCurrentMonth variable. 

Does anyone have any suggestions on how this may be done? 

Thanks in advance! 

Hallo, 

ich habe eine Button gemacht, mit dem ich die Daten neu laden kann. Grundsätzlich funktioniert das, aber nur mit meinem User (Professional Access) als Analyzer funktioniert der Button nicht, weil es dazu keine Rechte für diesen User gibt.

Kann das irgendwo eingestellt werden, dass ein bestimmter User dieses Recht zum aktualisieren bekommt ? natürlich nur über diesen Button und nicht generell.

anke

LG

Martin

I have a dimension that I created called Proposed Bucket.

Here is my if statement:

I want to create a measure that adds up certain elements of this proposed bucket. 

Hello,

I have a set of data which contains dates reaching from 01-03-2024 to 30-03-2024 and various dates in 2023.

Now I need to get the first date out of my data set but out if this year. This would be 01-03-2024.

When I use min(), minstring(), makedate() the result is either 01-01-2024 or the first date in the data which is some day in 2023.

Is it possible somehow to get the desired 01-03-2024?

Hello,

I have a issue with these data, i need to create Cumple? field, the rules is with the same id_vehiculo, with different CodTransito and PuntoCobro, the difference between fechahora(1) and fechahora(2) is <= 20 minutes

How can i do these?

Hello,
Is it possible to do cell sorting by color in qlikView?

I have such data and I would like to sort in such a way that records must be colored first.

Please help!!!

Hi,

In the example of getting the impersonation access token data-get-access-token is associated with the function that fetches the access token.
If I already have the access token because I fetched it earlier, how would I format it so that it fits the variable or if I have to, set it in the function getAccessToken()?