Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a visualization with State, City and Sales . In 4th column I want to display total sales for individual State.
Instead of displaying "-" at city level I want to display total sales as shown below:
State City Sales
CA SFO 100 600
CA LAX 200 600
CA SDF 300 600
TX DFW 100 1600
TX AUS 500 1600
TX HOU 1000 1600
How can I change the visualization ?
Also I have a State and City Filter. Can it display all states and cities by ignoring the filter values?
I get the following error message when I try to open an existing job:
An error has occurred. See error log for more details.
JsonIoException setting field 'flags' on target: Property: null with value: {}
I didn't make any migration and I've this exact same error message while opening a job.
I specify that I work on a project that I did not develop myself.
But the thing is : this job was opening really well last week and nothing has changed in the meantime.
I'm completely stuck right now 👾
Environment :
TOS 8.0.1
JDK 17
Thank you by advance
CTouu
I'm currently working on the data load using IF statements below but keep getting an error for line 3 & 4. Can someone help point out what I'm doing wrong? I've included the sample data attached for reference of what I want as an outcome. Thank you in advance.
1: date(CREATED_DATE, 'MM/DD/YYYY') as [Date Opened],
2: STATUS_C as [Status],
3: if([STATUS_C]= 'Closed', 'Closed','Open') as [Status Flag],
4: If ([STATUS_C] ='Open',today()-Created Date as [Days Aged from Open Date],
5: If ([STATUS_C] ='Open',If( [Days Aged] >= 0 and [Days Aged] < 90, replace( class([Days Aged],30),'<= x <','-') & ' Days', If( [Days Aged] >= 90, '90 Days+'))) as [Open Timeframe],
Hi all, below is a snapshot of my data which starts in Jan 1st 2023. I wish find total using set analysis with the following criteria:
1. If(Actual > Planned, Actual, Planned) and
2. Between Monday and Friday. Therefore, the correct total planned would be 11.
I don't wish to create a new variable or using the load editor.
Jobid | Date | Day | Planned Widgets | Actual Widgets | if Actual > Planned,Actual,Planned |
1 | 18-Mar-24 | Mon | 0 | 1 | 1 |
2 | 19-Mar-24 | Tue | 2 | 2 | 2 |
3 | 20-Mar-24 | Wed | 2 | 1 | 2 |
4 | 21-Mar-24 | Thu | 1 | 1 | 1 |
5 | 21-Mar-24 | Thu | 0 | 1 | 1 |
6 | 22-Mar-24 | Fri | 2 | 2 | 2 |
7 | 22-Mar-24 | Fri | 2 | 2 | 2 |
8 | 23-Mar-24 | Sat | 2 | 2 | 2 |
9 | 24-Mar-24 | Sun | 2 | 2 | 2 |
13 | 14 | 15 | |||
Mon to Fri | 9 | 10 | 11 |
Hello,
I am trying to create a table in Qlik Sense which is similar to the one below. But I am unable to do it because I cannot pick previous value from the resultant row and use it to calulate the next value in the same column.
Table:
In the above table, Availability is what I am trying to calculate. Formula for that would be "Column A-Column B" for priority 1 which will be 30 hours here for project 1. Then for priority 2, Result will be 30-3=27 i.e., Total Reult hours minus the hours required for 1st priority project. Then for the 3rd priority it will be 27-1=26 and so on. Question is how to use the value from resultant (Result) column to calculate the value for next row in the same column. Is there a function for this?
Thank you,
Apoorva.
Hi,
I have a problem where I need to get Transaction data from a OLE DB data source and then add en Excel file with manually entered Budget data for four different companies, the load data look like this compressed with the relevant fields for two of the companies as below.
I add the company name as Client field for every company and the joined data for Transactions table is working as supposed.
My problem is that the budget data is added on the last day of the month because it's mainly relevant to look at this aggregated per month. But since there are multiple transactions in the Transaction data the last day of the month every month the Budget data get multiplied for every occurrence of that date.
What I've found is that I should use a Link table to solve this issue but it seems that my skills is not enough to get the script right.
I would like to group interval of accounts for example revenue, material cost, gross profit etc. for set analysis and add a master calendar (or similar) to do analysis on different time periods. Is it possible to have a Link table for Client, account and date fields and then add grouping and master calendar connected in the Link table or do you have to do this in the Load for the original data sources?
hi,
I am using Add a Chart to Report block and when I try to find the object using "do lookup". It doesnt find my object.
The object is in a published sheet and I also got the object id using /options/developer mode.
Any clue about that?
Thanks in advance
suggestion: maybe this block should first select the sheet and then do a lookup on the elements inside the selected sheet. Because there are lots os elements in the app, so the lookup takes too long
Elevate your career with Connect. 15 Hands-on workshops and certifications for Data and Analytics.
Browse our helpful how-to's to learn more about navigating Qlik Community and updating your profile.
Your journey awaits! Join us by Logging in and let the adventure begin.
Qlik enables a frictionless migration to AWS cloud by Empresas SB, a group of Chilean health and beauty retail companies employing 10,000 people with 600 points of sale.
Qlik Luminary Stephanie Robinson of JBS USA, the US arm of the global food company employing 70,000 in the US, and over 270,000 people worldwide.
Join one of our Location and Language groups. Find one that suits you today!
A private group is for healthcare organizations, partners, and Qlik healthcare staff to collaborate and share insights..
Qlik Communityの日本語のグループです。 Qlik製品に関する日本語資料のダウンロードや質問を日本語で投稿することができます。
Welcome to the group for Brazil users. .All discussions will be in Portuguese.
Hear from your Community team as they tell you about updates to the Qlik Community Platform and more!