Is it possible to populate a filter pain based upon criteria from another field.

I have a table for document version, this contains [Version] and [Active] - [Active] has only two values, 'Active' or 'Deleted'

I want to show Version in my filter pane, but only if the Version is Active.

Thanks

Mark

Can a background color be set for cells in a trellis container using colormix2?  The charts are histograms and I would like to show deviation from the mean as one of two colors, with white being close to or at the mean.

If it can be done, I would assume it would be in the Master Visualization under Presentation, Styling / General / Background Color / By Expression, but not sure of the correct expression.  For regular tables it's something like:

=colormix2(
(rank(TOTAL column(1))/(NoOfColumns(TOTAL)/2))-1,
rgb(20,20,20),
rgb(100,100,100),
rgb(200,200,200)
)

But this does not work for Trellis Containers.

Hi guys,

I am new in Qlik sense.

I have a year and quarter filters, when I open the application, default selection is year 2021 and quarter Q2(previous quarter),how to do that,also I need to reflect 3 charts when selections applied.

Please help me anyone.

Thanks in advance 🙏

Regards,

Subba

I want to hide the contents of a dashboard until two filters are selected:

Filter 1: Standard Type

Filter 2: Standard Version

Once these are both selected the dashboard should display.  Is there a way to do this?

Thanks

Mark

Olá.

Por favor, há alguma solução de somase para o caso?

Tenho uma tabela com campo "NF", "NF vinculada", "Operação" e "Frete".

Operação há dois valores "Receita" ou "Remessa".

O valor do frete está ligado às notas de "remessa", mas preciso trazer a soma dos fretes junto às respectivas notas de "Receita".

Há menção da respectiva nota de "receita" para cada nota de "remessa".

Obrigado.

Hi all,

I have a request to investigate the feasibility of using a separate NLM package in conjunction with Qlik Sense Enterprise in order to implement automated bullet and sorting of data within Qlik.  I understand this is an available feature in Qlik Cloud, but as of right now our company is not moving to that product.  This is a new ask for me so I have no idea where to begin my investigation.

Has anyone encountered this ask before?  Is there a good starting place anyone can recommend?  Are there available links or past questions related to this ask that I can be directed to for review?

Thank you!

Hi,

I would like to allow users to see only particular filter fields according to their email addresses. Something like this in the expression for the field of a table object:

= if(USER.EMAIL='user1@domain.com', [FIELD1],
    if(USER.EMAIL='user2@domain.com', [FIELD2],
   [DEFAULT_FIELD])) // for other users

And in the access section of the load script something like

Section Access;

I would like to put the following values ​​in this order:
1. “Remuneration”
2. “Cotisation de l'employeur”

Also, I'd like the "Totaux" lign which is the total lign to be at the end and not at the beginning

Thank you

Hello community, I need to calculate the time between alarm records as expressed in the green column of the following table:

Alarm logs occur on different dates, locations and have different alarm descriptions. I need to calculate the time between the ALM type alarm and the RTN type alarm of the same location and description, and for cases where the last alarm record is of the ALM type (ID:2) I must calculate from the moment I am analyzing (in this case 02/24/2024 00:00). Thank you in advance for any kind of help you can give me.