Hi, i must visualize an icon for each competitor of my company.

When i choose an competitor, i would like see his logo images (ico).

I think to load in competitor table a new field with a url that link a ico files.

but it not work, what link (in what sintax form) i must to have?
Thanks

Regards
Ciro

I have the following code:

Load
if(Len(Trim("FIBRE 1") > 0 ) and "PERCENT 1" = '100' and wildmatch(trim("FIBRE 1"),
'Viscose LENZING™ ECOVERO™' ),
'ViscoseLENZINGECOVERO100',"FIBRE 1") as ViscoseLENZINGECOVERO100,
From......

This creates a field called  ViscoseLENZINGECOVERO100 where the Fibre 1 = 'Viscose LENZING™ ECOVERO™'  and Percent 1 =100

I also have Dimensions FIBRE 2 and FIBRE 3 and i need to add another level to the above to include

if FIBRE2 <0 or =0 (blank)

The end result should be load where fibre 1 = 'Viscose LENZING™ ECOVERO™'  and Percent 1 =100 and fibre 2 and fibre 3 blank

PLease can someone help to try and include this.

I have tried numerous ways but then lose the values which are ViscoseLENZINGECOVERO100

thank you in advance

Hello all,

Lets say I have a table with projects and phases along with costs

Phases:
load * inline [
Project, phase, startdate, enddate
P1, p1, 1/1/2020, 3/30/2020
p1, p2, 4/1/2020, 5/1/2020
]
costs
load * inline [
activity, account, CostDate, Cost
a1,Act1, 1/4/2020, 1000
a1,Act2, 2/4/2020, 3000
a1,Act3, 4/15/2020, 2000
]

I can create the master table of  to get to this, using joins, and interval match, but it duplicates the costs across the phases. (change Cost to Phase)

but what I need is (change Cost to Phase)  How do I keep the other phases null?

Hi, I have a set of data with customer, product purchased on weekly basis and quantity.

in the data, there are about 1000 customers. I only want to display the customers where there's a 30% drop or 30% jump in the quantity of orders for the most recent week. view the example below

As you can see john has been very consistent with his purchases except his latest purchase was huge compared to his previous purchase. this is the type of customer i want to view in form of a line chart displaying the trend. 

Most customers are always consistent with heir order quantity, but in case there is a 30% drop or a jump, we want to display that on a line chart showing the trend

I have this in my set analysis:-

Count of Order_num = 635
Count of Order_num where PSTN = Yes = 257

Its doing the first part correct and showing 635 - 257 = 378
= Count(Order_Num) - Count { <,PSTN_PROVIDE={'Yes'}> }ORDER_NUM)

however when I say * 1084 like so,
= Count(Order_Num) - Count { <,PSTN_PROVIDE={'Yes'}> }ORDER_NUM) * 1084

the answer should be 409,752 however its showing as -277,953 which is incorrect

I am still new to qlik sense.

I am trying to set custom colours for a stacked bar chart, where each category in a measure is a different colour.

I have trawled through the community board and found no solution that worked for me. I am not at the discretion of adding extra instructions into the load data as this request is for a once off report and there are business caveats atm.

The measure is a "status", with the categories being:

Approved = Green

Cancelled = black

In progress = cyan

Rejected = magenta

Returned = yellow

Incomplete = blue

This is the expression I have been playing with, but qlik continues to say "error in expression". everything is displaying in a green colour in the expression except the "if" part, which is blue.

I'm normally ok with formulas having worked in excel quite a bit. Where are am I going wrong? I'm sure it's something simple.

if([PR-Authorization Status]='Approved',([alpha,0,128,0]),if([PR-Authorization Status]='Cancelled',([alpha,0,0,0]),if([PR-Authorization Status]='In progress',([alpha,0,128,128]),if([PR-Authorization Status]='Rejected',([alpha,255,255,0]),if([PR-Authorization Status]='Returned',([alpha,255,0,255]),if([PR-Authorization Status]='Incomplete',([alpha,0,0,128])))))))

I've got two tables, Account and Contact inner join on AccountID

The Contact table has a JobFunction column populated with CEO or CFO or CTO.

Some AccountIDs may have multiple CEO, CTO or CTOs

I loaded the data with 

    if (not(JobFunction)='CEO', 1)as [Has CEO],
    if (not(JobFunction)='CTO', 1)as [Has CTO], 
    if (not(JobFunction)='CFO', 1)as [Has CFO]

I need to identify the AccountIDs that do not have CEO CTO CFO

My Table columns are AccountID  |  Has CEO  |  Has CFO  |  Has CTO

The result I get is multiple rows of data for each AccountID

Id like to return one row per AccountID with "Yes" or "No" in the Has CEO  Has CFO Has CTO columns

I also tried creating the Has CEO Has CFO Has CTO columns with a formula .. Something like if the sum of the AccountID row is zero, return "No" or else return "Yes". But, this only returns "Yes" for everything

=if(sum([Has CEO] <>0), 'Yes','No')

i want to study Qlik Sense personally, but i found that i cannot access .ap.qlikcloud.com in China.

i thought maybe it is blocked, so I do something to make I can access google, however it is still cannot be accessed in this case.

how can i use .ap.qlikcloud.com?

Thanks!