Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have an excel file with a table of measurements across 4 different regions. A measurement in a region generates a 1, and instead of having a NULL value with no measurement, I've instead created a -1.
When filtering >=0 for the regions no entries are uploaded. I've also tried with =1, >=1, but with the same result
"Results: 0 (generated:0, existing:0)"
What can I do to resolve this?
Region A | Region B | Region C | Region D |
-1 | -1 | -1 | -1 |
1 | -1 | -1 | -1 |
1 | -1 | -1 | -1 |
1 | -1 | -1 | -1 |
1 | -1 | -1 | -1 |
Would you be able to elaborate a little? I don't think I am able to understand the intent here
Hi,
The excel sheet contain measurements of network assets in each of the regions A, B, C, D. The purpose is to visualize the different measurements per asset and per region. Each asset belong to a certain type of technology: 2G, 3G, 4G.
In the column for Region, there is inserted 1 when there is a reading, and a -1 when there is none. I've changed the original NULL value to a -1 to make it easier to filter. If I maintain the NULL value then for each region I also get the measurements for all regions.
When I create the app, I connect to my excel sheet, and then go to filtering. I've set the filter for each Region to >= and the value 1. This way only the measurements for that region ought to be shown. However, all measurements and values get filtered out, and I get the feedback that there are no values in the tables.
I hope this makes sense.
Thanks in advance.
Would you be able to share your app so that we can see what is going on?
Hi,
I cannot publish the app. I have tried to attache the qvf file, but get the error message stating "The contents of the attachment doesn't match its file type."
Not sure what else to try...
You need to zip the file before you can upload it here.
Great. Here it comes
So, using the same script and your attached sample file... I get this by reloading...
Hi,
A couple of points, which might be important.
I only filter on Region A, B, C, D - which I thought would not affect any other column. But that might be a mistake?
I've double checked on the excel file to make sure there are 1 in the columns for the different regions. Below find an extract from the most recent test I've done this morning. Still the same result - Result: 0 (generated: 0, existing: 0). Can there be a problem in the upload from my C drive to Qlik?
I've attached both the excel file and the Qvf.
BaseId | AssetGroupId | Location | Level | RegionLoc | Region A | Region B | Region C | Region D | RegionsServed |
10821 | 0 | 0 | -1 | -1 | -1 | -1 | 0 | ||
10822 | 1A0010822 | 1A00 | 1 | A | 1 | -1 | -1 | -1 | A,B,C,D |
10823 | 1A0010823 | 1A00 | 1 | A | 1 | -1 | -1 | -1 | A,B,C,D |
10824 | 1A0010824 | 1A00 | 1 | A | 1 | -1 | -1 | -1 | A,B,C,D |
10825 | 1A0010825 | 1A00 | 1 | A | 1 | -1 | -1 | -1 | A,B,C,D |
10826 | 1A0010826 | 1A00 | 1 | A | 1 | -1 | -1 | -1 | A,B,C,D |
10827 | 1A0010827 | 1A00 | 1 | A | 1 | -1 | -1 | -1 | A,B,C,D |
10828 | 1A0010828 | 1A00 | 1 | A | 1 | -1 | -1 | -1 | A,B,C,D |
10829 | 1A0010829 | 1A00 | 1 | A | 1 | -1 | -1 | -1 | A,B,C,D |
10830 | 1A0010830 | 1A00 | 1 | A | 1 | -1 | -1 | -1 | A,B,C,D |
10831 | 1A0010831 | 1A00 | 1 | A | 1 | -1 | -1 | -1 | A,B,C,D |
10832 | 1A0010832 | 1A00 | 1 | A | 1 | -1 | -1 | -1 | A,B,C,D |
10833 | 1A0010833 | 1A00 | 1 | A | 1 | -1 | -1 | -1 | A,B,C,D |
10834 | 0 | 0 | -1 | -1 | -1 | -1 | 0 |