We have an application that reads cdc data from IBM DB2 source and writes to kafka target. There is a calculcated field defined for a table in table settings. We noticed that that calculated field value is null in target beforeRecord={} dataset but does the expected calculation in record={} dataset. Is this expected behaviour. Is there anyway to force it to calculate in beforeRecord too.

I have a 7 years experience in Qlik, been around for a while and seen how their product improving, I can say pretty much Qlik provides a solution for all my organization’s needs.

Looking into the job market, I rarely see any BI job that requires Qlik, and it feels like all my experience isn’t giving me any edge since all jobs require Tableau or Power BI.

What do you guys think about that? Shall I invest in learning from scratch a new tool? And what would it be?

Hi ,

I have a requirement  that when a user from a certain country logs into Qliksense and run the app , he should see data related to his country only. Is this possible within Qliksense? When a user who doesn't have the mapping country executes the app , no data should be returned.

Best Regards

Vamsi

I have a bar chart that uses two different bar charts:

And I want to make it so that the two bar charts get coloured by the two different measures' values, so I made this code to put in the Colour by Expression section:

IF(
    VALUELIST('Availability', 'Availability Aggr.') = 'Availability Aggr.',
    IF(
        [Availability Aggr.] > '99%',
        GREEN(),
        IF(
            [Availability Aggr.] > '89%',
            RGB(255, 165, 0),
            RED()
        )
    ),
    IF(
        VALUELIST('Availability', 'Availability Aggr.') = 'Availability',
        IF(
            [Availability] > '99%',
            GREEN(),
            IF(
                [Availability] > '89%',
                RGB(255, 165, 0),
                RED()
            )
        ),
        BLACK() // Default colour
    )
)

 Unfortunately as you can see, it always takes the default colour. 

I saw in previous posts people suggesting to colour the maste rmeasure by segments within the master measure itself, I tried that but it didn't work as well. 

Can anybody help me solve this ? Thank you!