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 tktcode, material and volume, sales, material, i need to sum of distinct volume for each ticket.

for same tktcode i have several rows are there because material is different , but volume and sales willl be same for each tktcode.

if sum(volume), if will sum of all volume is 80, idealy it should be, volume should 35 ,. , now i need to write to take sum of distinct volume for each ticketcode, if two tktcodes have same volume, it should consider both volumes because tktcodes are different ,. kindly help me to to get sum of distict volume for each tktcode. i need that in kpi. 

if i use sum( distinct volume), if will neglect volume if two different tktcode have same volume.

the formula it should interact with filters like some one slected some tkt codes, the formula should  according to filter selction. it's very urgent kindly help me

Goal: build a data filter in context, and use the context value in a talend componant.

I use a context to create a filter expression. The value of context is correctly builded 

When I show the value  

System.out.println( " string : " + context.sSearchExpr ); 

Result : 

string : ( !( input_row.isIntern ) ) && ( !( input_row.isExternalEmail )

Now, how do use my context value in any talend componant( tFilterRow or tJavaRow)

Help me

Thanks.

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!