Hello guys,

not a long time ago, from the links http://us-d.demo.qlik.com/download/ or https://demo.qlik.com/download/ it was possible to download not only the latest version of QW/QS Desktop, but also the previous ones, the manuals and many other interesting things, but now a day these links drive on a page where it's only possible to download the latest version on QW.

Am I doing something wrong or has something changed? Does someone know the new address which allows the same things that the previous one?

Thank you so much.

N. 

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.

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.

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

Can someone help me to achieve this?

This is the template I need to get. 

Doc Number contains -> Invoice Number and Doc Sequence Value as in order

Doc Type contains -> Invoice, Receipts, Credit Memo and Debit Memo as Types

Doc Date contains -> Invoice Date and Apply Date

Data modeling for the above-mentioned columns is below.

Black colored -> Doc Number Column

Blue Colored -> Doc Type

Red Colored -> Doc Date

Green lines are links in between these tables.

Could someone provide a way to achieve this template (1st image) using these tables?

Hello all,
I would like to label containers for the single parts in our assembly (small thumbnail, part number, quantity etc). For this I would use self-adhesive labels, so that afterwards per label a different item can be seen. But when I go to the desinger (Word report) and try to select labels, it doesn't work:

Is there a way to enable this? Gladly also other ideas/suggestions how to implement it.
In the end it should look like this:

Thanks in advance!
Manuel

Hello,

I am trying to create headcount measure using the employee table and with the information of hiring date and leaving date and the calendar table which are disassociated with each other to enable dynamic calculation based on the different points in time dimension.  I used the following measure hoping to see the HC to be calculated flexibly with respect to different points in time dimension, but the outcome of the calculation is zero.  I would appreciate it if anyone can point me in the right direction where I am going wrong with this measure.  

Thanks a lot for your help.

I am trying to make a calculated dimension from my 'Customer' dimension which only displays the customers that have the contain the word 'value' in their title. 

I have tried the expression below, but this in just giving me a 1 / 0 result (which I am assuming is yes / no) but would like the list of the 25 or so customers that I know have 'value in their name. 

=Wildmatch(Customer,'value*')

Thanks.