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.

Qlik sense app was developed on large screen with screen resolution 100%. However most people are using their laptops with recommended screen resolution of 150%. Some elements, like text box or variable input become too small for the text inside of it. KPIs for example, have property layout behavior that can be setup to responsive or fluid but there is no such option in textboxes or variable input. Is there a wat to make it work with any screen resolution?

Hello Qlik Community!

I'm looking to use a condition of an Issue Status (Closed/Open) to then calculate an age range. I have a nested IF statement. The first condition is stating if the issue is "Closed" to calculate the age range between the Issue Created Date, and Issue Closed Date. 

However, the second condition, if the issue is "Open", I would like to calculate the age range using the difference between the Issue Created Date, and today. 

I can get these to work independently, but not together. Can someone let me know what I may be missing? Here is what I'm using: 

=IF(ISSUE_STATUS_NAME='Closed',
IF(ISSUE_CLOSED_DATE2 - ISSUE_CREATED_DATE2 <= '0', '0 Days',
IF(ISSUE_CLOSED_DATE2 - ISSUE_CREATED_DATE2 <= '1', '1 Day',
IF(ISSUE_CLOSED_DATE2 - ISSUE_CREATED_DATE2 <= '2', '2 Days',
IF(ISSUE_CLOSED_DATE2 - ISSUE_CREATED_DATE2 <= '5', '3-5 Days',
IF(ISSUE_CLOSED_DATE2 - ISSUE_CREATED_DATE2 <= '7', '6-7 Days',
IF(ISSUE_CLOSED_DATE2 - ISSUE_CREATED_DATE2 <= '10', '8-10 Days',
IF(ISSUE_CLOSED_DATE2 - ISSUE_CREATED_DATE2 <= '14', '11-14 Days',
IF(ISSUE_CLOSED_DATE2 - ISSUE_CREATED_DATE2 <= '30', '15-30 Days',
IF(ISSUE_CLOSED_DATE2 - ISSUE_CREATED_DATE2 <= '60', '31-60 Days',
IF(ISSUE_CLOSED_DATE2 - ISSUE_CREATED_DATE2 <= '90', '61-90 Days',
IF(ISSUE_CLOSED_DATE2 - ISSUE_CREATED_DATE2 >= '91', '91+ Days',
IF(ISSUE_STATUS_NAME='Open',
IF(Today() - ISSUE_CREATED_DATE2 <= '0', '0 Days',
IF(Today() - ISSUE_CREATED_DATE2 <= '1', '1 Day',
IF(Today() - ISSUE_CREATED_DATE2 <= '2', '2 Days',
IF(Today() - ISSUE_CREATED_DATE2 <= '5', '3-5 Days',
IF(Today() - ISSUE_CREATED_DATE2 <= '7', '6-7 Days',
IF(Today() - ISSUE_CREATED_DATE2 <= '10', '8-10 Days',
IF(Today() - ISSUE_CREATED_DATE2 <= '14', '11-14 Days',
IF(Today() - ISSUE_CREATED_DATE2 <= '30', '15-30 Days',
IF(Today() - ISSUE_CREATED_DATE2 <= '60', '31-60 Days',
IF(Today() - ISSUE_CREATED_DATE2 <= '90', '61-90 Days', '91+ Days')))))))))))))))))))))))

Thanks! 

Just updated, to the latest May 2022 version.

I'm getting SYS,GENERAL_EXCEPTION,Object reference not set to an instance of an object, when trying to rebuild a marts that have mostly reference dims (one local dim).

The main mart - all local dims generated with no issues.

Where are the log files from the generation - ie. where is SYS,GENERAL_EXCEPTION,Object reference not set to an instance of an object this logged.  I thought I searched all the logs, I cant find where this error exists so I can fix it.

Ron