Hello, I'm asking you for help because

I've been trying for several hours to find a solution to one of my requests.

I would like my bars on a bar graph to be different colours depending on an expression.

My graph represents the number of defects: (dimension = defaut and measure: count(defaut). This graph is dynamic and I have created a filter (field: ANNEE.SEMAINE on the sheet. 

I can see my graph evolving according to the weeks selected. All is fine

In order to be more precise, I would like the bars of my graph to have a different colour depending on the average number of faults registered on the fault concerned per week where the fault has already been declared. Then I would like the colour to be red if it is above the average, orange between 50 and 70¨% and green if it is below 50%.

Can you help me write this expression?

I tried in the first time this expression but not working:

""if(Sum(defaut) > Avg(Aggr(Sum(defaut), TOTAL ANNEE.SEMAINE)), rgb(255,0,0), rgb(0,0,255))"""

Thank you for advance

Hi,

I've added section access to my dashboard and only want to show certain fields for certain people. For example, I want to show UK, USA and Australia for myself. When opening the dashboard the only 3 Areas I can see are the 3 mentioned in a selection box, however the dashboard is still showing values for all Areas, not just the 3 i have access to. What i mean by that is, for example, UK = £100, USA = £200, Australia = £150. I would expect to see an overall total of £450, however I'm seeing £2500 which is the total of ALL areas. Any help would be great.

Kev

I have a worksheet with multiple tables.

example:

The tables on the bottom have to be filtered by the filter 'team'.

the table on the top has to be filtered on a hard value, independent of what is selected in the filter in the blue square.

I created a filter for the upper table with the expression:

if(Team='Staf', Groep,)

which worked.

But then I created the lower 2 tables which do have to be filtered by the selected value in the blue square (only 1 selected possible). However, this changes the table on the top also.

I then thought: I create an alternate state for the table on the top so the selection in 'Team' doesn't affect this table, but I ended up with 'Team' being in the selection bar, showing 'selection in 2 states'.

I do not want selections in 2 states. I only want selections in 1 state.

How can I achieve this? Is it possible to have the top table filtered on a hard coded value and not being affected by any selection made in this variable AND the variable not having 'selections in 2 states' in the active selections bar? I want to be able to quickly change the selection of 'team' as I expect the user not to understand for which state the selection has to be changed.

How can I reduce the margins of text fields?

I have a text field, but text is barely visible because half of the field goes to waste because of the margins.

(how) can I get rid of these margins? I just want to use the area of the text field and I don't need an application to decide for me how much spuch I can have.

Cross-sell opportunities - market basket analysis. Try to find the probabilities of two unique items being sold at the same time period (maybe within same month-year, or just year) how can i achieve these

Hi there,

I am not sure whether this is a excel question or can be done by Qliksense. I have database like below:

I would like to partially transform 'task' column value into new columns and bring 'date' column values into the corresponding column:

Can Qliksense do this? What script to write?

Many thanks!!

I'm using Qlik Sense Enterprise for Windows and need to change an app's theme programmatically. Can someone guide me on how to do this using either the Engine API or the QRS API?

Hallo Zusammen,

wir haben seit dem Update auf Version "Feb. 2024" (inkl. Patch 4) ein Problem bei der Abfrage von MySQL Daten. Sobald in Abfragen im Spaltenname ein Unterstrich "_" vorhanden ist, liefert Qlik leere Daten in dieser Spalte zurück.

Auch den Spaltenname in der Abfrage zu maskieren [auftrag_position_id] bringt keine Verbesserung.

Für eure Unterstützung wäre ich euch dankbar!