Hi team, 

Question is regarding passing Score of Certification exams. When I taken the Qlik Sense Business analyst certification-2022 exam( AUG-2023 )passing Score is 72% , Now in the official Website of Qlik https://www.qlik.com/us/services/training/certifications-and-qualifications/faqs Showing Passing Score is 62%.

It's Officially Changed , Please let me know , any one have taken QSBA2022 Exam Recently.

Thanks !!!!

Hello everyone,

regarding the above topic, my idea was to create a variable (e.g. vChangeTable with value 1) and assign this variable to the table within the collection box under "Display condition" in order to then save the created variable in the button with "Action" - "Set variable".

Unfortunately, this does not work. Does anyone have any ideas?

Many thanks in advance

Maurice

Translated with DeepL.com (free version)

Hi,

I want to add reference line on my x- axis.
my x-axis is my ItemID.
my Y axis is cumulative margin.

I tried to crate whale chart and I want to know where is the spot when my whale chart start  to descending with the reference line.

this is my line chart so far:

I tried to add the reference line with this expression:

Aggr(If(Rangesum(above(total ROUND(sum(margin)),0,RowNo())) = Max(total Rangesum(above(total ROUND(sum(margin)),0,RowNo()))), ItemID), ItemID)

but I don't see any line on my X-axis..

Can someone help me please? 

Hello everyone, 

I want to change the default color scheme to one I found online... (when i select to color by measures)

how can i do that? 

thanks!!!

Hello Everyone,

I have an issue with the Set expression in KPI chart. i'm calculating the percentage in my expression i'm using Parent incident id for this column is having Null values i want to calculate the Null values. but while calculating the t column not considering. please find the below expression

Num(sum({<Goal={'Cpi - Critical - Restore'},ID={'365'},Reported_13Month={1},[Status]={0},[Parent Incident ID]={'Null'}>}[Ticket Count])/sum({<Goal={'Cpi - Critical - Restore'},ID={'365'},Reported_13Month={1},[Parent Incident ID]={'Null()'}>}[Ticket Count]),'##.##%')

please anyone can help me on this.

Hello Everyone,

i have one some data which all are loaded to qlik tables in Sql server that data has been using in qlik Qvd. As per customer requirement we have changed filters and applied new logics in the Backend and some data has been updated and deleted in backend. when i'm checking in qliksense that data not reflecting. i have checked with collegues they were saying once data store in the qvd's there no way to modify data in qliksense. is there anyway to update data in Qlik sense.

can anyone help me on this request.

Hello

I need some help 😉

I have dimension AA with values 'one' and 'two'

I have another dimension BB with values 'red' and 'green'

I have several  variables:

one_red = 1,  one_green=2, two_red=3, two_green=4

how can I build my formula so that when looping through the table, each cell in the table is the right combination?

Pivot table: 

               red  |  green

one          1          2

two           3         4

I tried : $(=Only(AA)) & '_' & $(=Only(BB))   right but not evaluated as a varible 😞

Any help will be welcome... Thank's in advance