When using color > By expression instead of Auto color at a bar chart or combo,   none of pick(match(), if(), and variable set works. 

pick(match(status,'approve','cancel'), yellow(), red())

if(status='approve', yellow(), if(status='cancel', red()))

pick(match(status,'approve','cancel'), $(vapprove), $(vcancel))

I set dimension and measure as below.

Count({$ <status={'approve'}>} station)

Count({$ <status={'cancel'}>} station)

 and the data table is 

test:
load ActionDate, if ( isnull(Project ),'Unknown', Project) as Project , Approval
Inline [ ActionDate, Project , Approval
2/4/2021, a , cancel
2/4/2021, b, approve
2/4/2021, c, approve
2/5/2021, b, cancel
2/5/2021, a, approve
2/5/2021,c,approve
2/8/2021, c, approve
2/10/2021, a, approve
2/10/2021, b, cancel
2/10/2021, c, approve
3/15/2021,a, approve
3/15/2021, c, cancel
3/16/2021, c, cancel
];

When using color > By expression instead of Auto color at a bar chart or combo,   none of pick(match(), if(), and variable set works. 

pick(match(status,'approve','cancel'), yellow(), red())

if(status='approve', yellow(), if(status='cancel', red()))

pick(match(status,'approve','cancel'), $(vapprove), $(vcancel))

I set dimension and measure as below.

Count({$ <status={'approve'}>} station)

Count({$ <status={'cancel'}>} station)

 and the data table is 

test:
load ActionDate, if ( isnull(Project ),'Unknown', Project) as Project , Approval
Inline [ ActionDate, Project , Approval
2/4/2021, a , cancel
2/4/2021, b, approve
2/4/2021, c, approve
2/5/2021, b, cancel
2/5/2021, a, approve
2/5/2021,c,approve
2/8/2021, c, approve
2/10/2021, a, approve
2/10/2021, b, cancel
2/10/2021, c, approve
3/15/2021,a, approve
3/15/2021, c, cancel
3/16/2021, c, cancel
];

Hello there!

I am using the following expression as a measure while designing a bar graph.

The result is as expected but the visualization is taking some time to load up on selections(understandable as there are many conditions in the expression). Is there any other simple/effective way to achieve this so that the performance wouldn't be low.

My expression:

if(getselectedcount([School Year])=0 and valuelist('At-Risk','CFSA','English Learner','Homeless','Migrant Status','Military Connected','Students with Disabilities'
,'Gender(Male)','Gender(Female)','Gender(Non-binary)')
='Students with Disabilities',
if(Count({<[Type]={'Current'},[School Year]={'2020-2021'},[SWD Status]={'YES'}>} distinct USI)
/Count({<[Type]={'Current'},[School Year]={'2020-2021'}>} distinct USI)<0.001,'<0.1%',
Count({<[Type]={'Current'},[School Year]={'2020-2021'},[SWD Status]={'YES'}>} distinct USI)
/Count({<[Type]={'Current'},[School Year]={'2020-2021'}>} distinct USI)),

if(getselectedcount([School Year])=0 and valuelist('At-Risk','CFSA','English Learner','Homeless','Migrant Status','Military Connected','Students with Disabilities'
,'Gender(Male)','Gender(Female)','Gender(Non-binary)')
='At-Risk',
if(Count({<[Type]={'Current'},[School Year]={'2020-2021'},[At-Risk]={'YES'}>} distinct USI)
/Count({<[Type]={'Current'},[School Year]={'2020-2021'}>} distinct USI)<0.001,'<0.1%',
Count({<[Type]={'Current'},[School Year]={'2020-2021'},[At-Risk]={'YES'}>} distinct USI)
/Count({<[Type]={'Current'},[School Year]={'2020-2021'}>} distinct USI)),

if(getselectedcount([School Year])=0 and valuelist('At-Risk','CFSA','English Learner','Homeless','Migrant Status','Military Connected','Students with Disabilities'
,'Gender(Male)','Gender(Female)','Gender(Non-binary)')
='English Learner',
if(Count({<[Type]={'Current'},[School Year]={'2020-2021'},[English Learner Status]={'YES'}>} distinct USI)
/Count({<[Type]={'Current'},[School Year]={'2020-2021'}>} distinct USI)<0.001,'<0.1%',
Count({<[Type]={'Current'},[School Year]={'2020-2021'},[English Learner Status]={'YES'}>} distinct USI)
/Count({<[Type]={'Current'},[School Year]={'2020-2021'}>} distinct USI)),

if(getselectedcount([School Year])=0 and valuelist('At-Risk','CFSA','English Learner','Homeless','Migrant Status','Military Connected','Students with Disabilities'
,'Gender(Male)','Gender(Female)','Gender(Non-binary)')
='CFSA',
if(Count({<[Type]={'Current'},[School Year]={'2020-2021'},CFSA={'YES'}>} distinct USI)
/Count({<[Type]={'Current'},[School Year]={'2020-2021'}>} distinct USI)<0.001,'<0.1%',
Count({<[Type]={'Current'},[School Year]={'2020-2021'},CFSA={'YES'}>} distinct USI)
/Count({<[Type]={'Current'},[School Year]={'2020-2021'}>} distinct USI)),

if(getselectedcount([School Year])=0 and valuelist('At-Risk','CFSA','English Learner','Homeless','Migrant Status','Military Connected','Students with Disabilities'
,'Gender(Male)','Gender(Female)','Gender(Non-binary)')
='Homeless',
if(Count({<[Type]={'Current'},[School Year]={'2020-2021'},[Homeless Status]={'YES'}>} distinct USI)
/Count({<[Type]={'Current'},[School Year]={'2020-2021'}>} distinct USI)<0.001,'<0.1%',
Count({<[Type]={'Current'},[School Year]={'2020-2021'},[Homeless Status]={'YES'}>} distinct USI)
/Count({<[Type]={'Current'},[School Year]={'2020-2021'}>} distinct USI)),

if(getselectedcount([School Year])=0 and valuelist('At-Risk','CFSA','English Learner','Homeless','Migrant Status','Military Connected','Students with Disabilities'
,'Gender(Male)','Gender(Female)','Gender(Non-binary)')
='Military Connected',
if(Count({<[Type]={'Current'},[School Year]={'2020-2021'},[Military Connected Status]={'YES'}>} distinct USI)
/Count({<[Type]={'Current'},[School Year]={'2020-2021'}>} distinct USI)<0.001,'<0.1%',
Count({<[Type]={'Current'},[School Year]={'2020-2021'},[Military Connected Status]={'YES'}>} distinct USI)
/Count({<[Type]={'Current'},[School Year]={'2020-2021'}>} distinct USI)),

if(getselectedcount([School Year])=0 and valuelist('At-Risk','CFSA','English Learner','Homeless','Migrant Status','Military Connected','Students with Disabilities'
,'Gender(Male)','Gender(Female)','Gender(Non-binary)')
='Migrant Status',
if(Count({<[Type]={'Current'},[School Year]={'2020-2021'},[Migrant Status]={'YES'}>} distinct USI)
/Count({<[Type]={'Current'},[School Year]={'2020-2021'}>} distinct USI)<0.001,'<0.1%',
Count({<[Type]={'Current'},[School Year]={'2020-2021'},[Migrant Status]={'YES'}>} distinct USI)
/Count({<[Type]={'Current'},[School Year]={'2020-2021'}>} distinct USI)),

if(getselectedcount([School Year])=0 and valuelist('At-Risk','CFSA','English Learner','Homeless','Migrant Status','Military Connected','Students with Disabilities'
,'Gender(Male)','Gender(Female)','Gender(Non-binary)')
='Gender(Male)',
if(Count({<[Type]={'Current'},[School Year]={'2020-2021'},Gender={'Male'}>} distinct USI)
/Count({<[Type]={'Current'},[School Year]={'2020-2021'}>} distinct USI)<0.001,'<0.1%',
Count({<[Type]={'Current'},[School Year]={'2020-2021'},Gender={'Male'}>} distinct USI)
/Count({<[Type]={'Current'},[School Year]={'2020-2021'}>} distinct USI)),

if(getselectedcount([School Year])=0 and valuelist('At-Risk','CFSA','English Learner','Homeless','Migrant Status','Military Connected','Students with Disabilities'
,'Gender(Male)','Gender(Female)','Gender(Non-binary)')
='Gender(Female)',
if(Count({<[Type]={'Current'},[School Year]={'2020-2021'},Gender={'Female'}>} distinct USI)
/Count({<[Type]={'Current'},[School Year]={'2020-2021'}>} distinct USI)<0.001,'<0.1%',
Count({<[Type]={'Current'},[School Year]={'2020-2021'},Gender={'Female'}>} distinct USI)
/Count({<[Type]={'Current'},[School Year]={'2020-2021'}>} distinct USI)),

if(getselectedcount([School Year])=0 and valuelist('At-Risk','CFSA','English Learner','Homeless','Migrant Status','Military Connected','Students with Disabilities'
,'Gender(Male)','Gender(Female)','Gender(Non-binary)')
='Gender(Non-binary)',
if(Count({<[Type]={'Current'},[School Year]={'2020-2021'},Gender={'Non-binary'}>} distinct USI)
/Count({<[Type]={'Current'},[School Year]={'2020-2021'}>} distinct USI)<0.001,'<0.1%',
Count({<[Type]={'Current'},[School Year]={'2020-2021'},Gender={'Non-binary'}>} distinct USI)
/Count({<[Type]={'Current'},[School Year]={'2020-2021'}>} distinct USI)),

if(getselectedcount([School Year])<>0 and valuelist('At-Risk','CFSA','English Learner','Homeless','Migrant Status','Military Connected','Students with Disabilities'
,'Gender(Male)','Gender(Female)','Gender(Non-binary)')
='Students with Disabilities',
if(Count({<[Type]={'Current'},[SWD Status]={'YES'}>} distinct USI)
/Count({<[Type]={'Current'}>} distinct USI)<0.001,'<0.1%',
Count({<[Type]={'Current'},[SWD Status]={'YES'}>} distinct USI)
/Count({<[Type]={'Current'}>} distinct USI)),
if(getselectedcount([School Year])<>0 and valuelist('At-Risk','CFSA','English Learner','Homeless','Migrant Status','Military Connected','Students with Disabilities'
,'Gender(Male)','Gender(Female)','Gender(Non-binary)')
='At-Risk',
if(Count({<[Type]={'Current'},[At-Risk]={'YES'}>} distinct USI)
/Count({<[Type]={'Current'}>} distinct USI)<0.001,'<0.1%',
Count({<[Type]={'Current'},[At-Risk]={'YES'}>} distinct USI)
/Count({<[Type]={'Current'}>} distinct USI)),
if(getselectedcount([School Year])<>0 and valuelist('At-Risk','CFSA','English Learner','Homeless','Migrant Status','Military Connected','Students with Disabilities'
,'Gender(Male)','Gender(Female)','Gender(Non-binary)')
='English Learner',
if(Count({<[Type]={'Current'},[English Learner Status]={'YES'}>} distinct USI)
/Count({<[Type]={'Current'}>} distinct USI)<0.001,'<0.1%',
Count({<[Type]={'Current'},[English Learner Status]={'YES'}>} distinct USI)
/Count({<[Type]={'Current'}>} distinct USI)),
if(getselectedcount([School Year])<>0 and valuelist('At-Risk','CFSA','English Learner','Homeless','Migrant Status','Military Connected','Students with Disabilities'
,'Gender(Male)','Gender(Female)','Gender(Non-binary)')
='CFSA',
if(Count({<[Type]={'Current'},[CFSA]={'YES'}>} distinct USI)
/Count({<[Type]={'Current'}>} distinct USI)<0.001,'<0.1%',
Count({<[Type]={'Current'},[CFSA]={'YES'}>} distinct USI)
/Count({<[Type]={'Current'}>} distinct USI)),
if(getselectedcount([School Year])<>0 and valuelist('At-Risk','CFSA','English Learner','Homeless','Migrant Status','Military Connected','Students with Disabilities'
,'Gender(Male)','Gender(Female)','Gender(Non-binary)')
='Homeless',
if(Count({<[Type]={'Current'},[Homeless Status]={'YES'}>} distinct USI)
/Count({<[Type]={'Current'}>} distinct USI)<0.001,'<0.1%',
Count({<[Type]={'Current'},[Homeless Status]={'YES'}>} distinct USI)
/Count({<[Type]={'Current'}>} distinct USI)),
if(getselectedcount([School Year])<>0 and valuelist('At-Risk','CFSA','English Learner','Homeless','Migrant Status','Military Connected','Students with Disabilities'
,'Gender(Male)','Gender(Female)','Gender(Non-binary)')
='Military Connected',
if(Count({<[Type]={'Current'},[Military Connected Status]={'YES'}>} distinct USI)
/Count({<[Type]={'Current'}>} distinct USI)<0.001,'<0.1%',
Count({<[Type]={'Current'},[Military Connected Status]={'YES'}>} distinct USI)
/Count({<[Type]={'Current'}>} distinct USI)),
if(getselectedcount([School Year])<>0 and valuelist('At-Risk','CFSA','English Learner','Homeless','Migrant Status','Military Connected','Students with Disabilities'
,'Gender(Male)','Gender(Female)','Gender(Non-binary)')
='Migrant Status',
if(Count({<[Type]={'Current'},[Migrant Status]={'YES'}>} distinct USI)
/Count({<[Type]={'Current'}>} distinct USI)<0.001,'<0.1%',
Count({<[Type]={'Current'},[Migrant Status]={'YES'}>} distinct USI)
/Count({<[Type]={'Current'}>} distinct USI)),
if(getselectedcount([School Year])<>0 and valuelist('At-Risk','CFSA','English Learner','Homeless','Migrant Status','Military Connected','Students with Disabilities'
,'Gender(Male)','Gender(Female)','Gender(Non-binary)')
='Gender(Male)',
if(Count({<[Type]={'Current'},Gender={'Male'}>} distinct USI)
/Count({<[Type]={'Current'}>} distinct USI)<0.001,'<0.1%',
Count({<[Type]={'Current'},Gender={'Male'}>} distinct USI)
/Count({<[Type]={'Current'}>} distinct USI)),
if(getselectedcount([School Year])<>0 and valuelist('At-Risk','CFSA','English Learner','Homeless','Migrant Status','Military Connected','Students with Disabilities'
,'Gender(Male)','Gender(Female)','Gender(Non-binary)')
='Gender(Female)',
if(Count({<[Type]={'Current'},Gender={'Female'}>} distinct USI)
/Count({<[Type]={'Current'}>} distinct USI)<0.001,'<0.1%',
Count({<[Type]={'Current'},Gender={'Female'}>} distinct USI)
/Count({<[Type]={'Current'}>} distinct USI)),
if(getselectedcount([School Year])<>0 and valuelist('At-Risk','CFSA','English Learner','Homeless','Migrant Status','Military Connected','Students with Disabilities'
,'Gender(Male)','Gender(Female)','Gender(Non-binary)')
='Gender(Non-binary)',
if(Count({<[Type]={'Current'},Gender={'Non-binary'}>} distinct USI)
/Count({<[Type]={'Current'}>} distinct USI)<0.001,'<0.1%',
Count({<[Type]={'Current'},Gender={'Non-binary'}>} distinct USI)
/Count({<[Type]={'Current'}>} distinct USI))

))))))))))
))))))))))

Thanks,

Sai.

Hello Qlik fam!

I am trying to hard code the values in measure for a bar graph if the percentages are too low.

My expression:

if(Valuelist('Ever-Enrolled','Audit')='Ever-Enrolled' and
(count({<Type={'Current'},[School Year]={'2020-2021'}>}distinct USI)/
count(total {<Type={'Current'},[Race/Ethnicity]=,[School Year]={'2020-2021'}>}distinct USI))<0.001,num(0.001,'<0.0%'),

if(Valuelist('Ever-Enrolled','Audit')='Ever-Enrolled' and
(count({<Type={'Current'},[School Year]={'2020-2021'}>}distinct USI)/
count(total {<Type={'Current'},[Race/Ethnicity]=,[School Year]={'2020-2021'}>}distinct USI))>=0.001,

(count({<Type={'Current'},[School Year]={'2020-2021'}>}distinct USI)/
count(total {<Type={'Current'},[Race/Ethnicity]=,[School Year]={'2020-2021'}>}distinct USI)),

if(Valuelist('Ever-Enrolled','Audit')='Audit' and
(count({<Category={'Historic'},[School Year]={'2020-2021'}>}distinct USI)/
count(total {<Category={'Historic'},[Race/Ethnicity]=,[School Year]={'2020-2021'}>}distinct USI))<0.001,num(0.001,'<0.0%'),

if(Valuelist('Ever-Enrolled','Audit')='Audit' and
(count({<Category={'Historic'},[School Year]={'2020-2021'}>}distinct USI)/
count(total {<Category={'Historic'},[Race/Ethnicity]=,[School Year]={'2020-2021'}>}distinct USI))>=0.001,

(count({<Category={'Historic'},[School Year]={'2020-2021'}>}distinct USI)/
count(total {<Category={'Historic'},[Race/Ethnicity]=,[School Year]={'2020-2021'}>}distinct USI))

))))

The highlighted part above from my expression is where I am trying to use multiple options but nothing really worked out. The above expression is giving '0.10%' but my goal is to get '<0.1%'. I am able to implement the logic without any problem in grouped bar chart but the stacked bar chart is not giving me the expected result.

Any help regarding this would be appreciated!

Thanks,

Sai.

Hello All,

I am new to the Qlik Sense. We had a programmer that already set the Qlik Sense for my company but now he isn't working for us any longer and i do not know how to "reload" "refresh" the data on Qlik Sense.

I would appreciate if someone can take me through the steps on where to go and to set it automatically to refresh the data.

The data which is used on Qlik Sense is through our company's stock and accounting software through our server.

Thank you in advance.

Hello Community,

Hoping I can get some help with creating a link within the Operations Monitor dashboard to the Task reload logs.  To do that I'm assuming I would just enter the file path and then build out the file name by combining the various elements that make up the name.

de2edd7c-1ddf-4c7c-9a09-dd82d862177a.20210723T140012.961-0400.28179F83CB023EB35191.log

It appear it is delimitated by a period with the first part being the AppId.  The second being date separated by a T and then timestamp.  Not sure what is 961-0400 and the last piece 28179F83CB023EB35191.

Any ideas or suggestions?

Thanks in advance.

Hi,

I am using Qlik Sense enterprise cloud April 2020 Patch 6.

I have created a scatter plot and want to include few more dimensions as Tooltip, but its not showing anything on chart.

In the data model - Fail stage is having 1 - 1 mapping with the ID i.e. 5155440.

Expression I have used is quite simple  "only(fail_stage)", Please advise.

Hello all,

i want to use the datepicker, but nothing is appearing as datefield. 

start and endate are saved like this in the database: 2021-07-13 11:03:58

I'm loading my data like this in Qlik: 

LOAD id,
username,
Date(enddate) as EndDate,
Date(startdate) As StartData,
interval(enddate-startdate) as Duration;

[runs]:
SELECT id,
startdate,
enddate,
username,
FROM `database`.runs;

Unfortunately there is no value to select in the datepicker. i guess the startdate and endate are not recognized as date.

Can someone help me?

You asked, and we listened. We've continued to work on plans to deliver an unprecedented experience with Waterfall Charts in Qlik Sense. And we are pleased to announce that several new valuable features are now there to improve the way you explore not only a by-category but also a by-subcategory breakdown of metrics! 🎇

⚡️ Check out what's new in our Stacked Waterfall Chart for Qlik Sense — just upgraded with the July release of the AnyChart Qlik Extension:
✅Cross-category arrow connectors
✅Split total display
✅Outside labels
✅More settings for axes and grids
✅Union tooltip for subcategory stacks
✅Vertical layout

Learn more in our blog 👇
➡️https://qlik.anychart.com/news/stacked-waterfall-upgrade/

What else do you need in Qlik Sense? Just let us know! 😎