Hello,
I have a price list with a “valid from” date.
I always want to load the current price in the load script.

How can I do that? I thought maybe something similar to what was written in the title.

Can you help me?

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 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

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

hello All,

Hello All,

Does anyone facing the dataloading issues with license monitor app in qlik sense? 

License app error:

Olá!

Gostaria de solicitar a melhoria do gráfico de pivot table para termos a opção de escolher a cor da linha de total baseado em um critério/expressão.

Hi

I'm trying to connect ServiceNow data in Qlik cloud,
I was able to connect to ServiceNow instance I see tables but when I click on any of them to see details and pick columns there is nothing but a spinning circle and an error about Qlik Sense error.