Hi Team,

I am trying to use the below expression but not able to get the exact count.

Could you please check and advice what i am missing or doing wrong?

if(match(Status_Business,'Unable To Remediate (Requires Human Intervention)')>0 and "Closure Reason"='' or
Not wildmatch(("Closure Reason") , '*Received Tech/Business Signed Off*','*Received Tech/Business Sign Off*',
'*Received tech/business signoff*','*Received Tech/ Business signoff*','*Received Tech/ Business Sign off*'),0,1)

I am getting count with other texts as well so need your expertise.

Regards,

Richard

Hello Team,

Is there a way to limit the throughput(kbytes/sec) to a specific number? The reason behind is the network bandwidth only supports 200 MB of bandwidth an when the throughput reaches close to that number, the replicate task fails with a communication link failure. Help will be appreciated.

Thanks,

Nabeel

Hi all

in a Qlik Sense Saas Environment I connect to a REST data source wich delivers document information from customers.

The documentLink is as base64 endocded URL to directly open the document in the browser.

In the sense app the documentLink should be displayed as link so the user can easily open the document in the browser.

But therefore I need to base64/decode the URL in the load script or the table (I did it manually here for example).

Does anyone know how I can automatically decode this link so that I can use it in the app?

Thanks so much for your help, Andy

Hi,

This may not be possible however, is it possible if I have a list of roads and postal codes(Zip codes) linked with global coordinates to setup a page whereby you can search for coordinates and it would return all roads within a set mile radius e.g. 1 mile?

I could have just a postal code search however I've found that either side of a road could have a different postal code.

I don't want to have a road name search e.g. high street would bring back 1000s of results. You would need a multitude of filters

With the coordinates you could input latitude and longitude and then a range of roads would appear 

Hello 

so i have to show values of sales for the past 30 days , including the days which have 0 value for sales 

Usually in qlik sense chart , i can do it with a toggle button of show null values /show missing values

But i am using a Vizlib chart which doesnt have that option , so the only way to correct it is with expression 

I saw that Sum({1}0) works 

But it doesnt work in my case ., because i use a count statement , could someone help me solve this ...

Basically, How to  use a set analysis statement to show 0 values for dates and show all 30 dates

I want to get the previous quarter dynamically based on the selection in Month field. In this case the data is available for Oct-21 (Q4-21) and I want to get Jun-21(Q2-21) to show in label of KPI.

Currently this is the formula I am using : 'Q'&ceil(Month(QuarterStart(max(FDAY),-1))/3) which is not working for this case.

Can you guide me on the correct formula I have to use?

Hello,

I was wondering whether there is QlikSense app that shows the usage statistics for all the Qlik apps such as the number of users who accessed the app, number of clicks on each sheet etc. If someone could point me to such an app that would be very helpful. I am using QlikSense SaaS Cloud version. TIA.

Hi all,

I would appreciate if you could help me with this one. Based on the attached file I need to have a chart that has dimension for x-axis from the column Next 3 months. But the dimensions should be limited only to cells that are in the same row with the cells 01.01.2023 from the column Data Month – Year (current cycle). I.e. on the x-axis we should have Feb, Mar and Apr. This file will be appended every month and therefore Next 3 months dimension should be dynamic, i.e. always linked to the current cycle. Column Next 3 months will be populated accordingly. Therefore during the next cycle (Data Month – Year  01.02.2023) x-axis should have Mar, Apr and May.