I have asked number of times on this forum about formatting of a table and so far I have not received any help. Can anyone help me with transformation of the table. Table is attached with the mail. I need to format the table in 4 fields like:
Age Sex Ethnicity Count Percent
I do not want to include medical conditions, which is given in the table, to be included in any of the fields. If possible, a seperate field.
First, you should know that nobody in this forum gets paid to answer questions. Experienced developers spend their personal time to help other developers, free of charge. So, while your frustration might be understandable, it's not appropriate here.
Second, the reason you are not getting any responses is the way you formulate your questions. It's very vague, and it's not clear to me what are you actually struggling with. When I hear "formatting the table", I'm thinking about fonts and colors and headers etc., but that doesn't appear to be your problem. In order to get help, please formulate your questions more specifically, preferably using Qlik terminology.
Lastly, it looks like you lack some basic understanding of Qlik data processing. I think you can benefit a lot from some beginner's classes - many of them are available online, on the Qlik website and on YouTube, and many of them are free. Kindly spend time to get some basic understanding of the product and its features, before you begin spending others' time on the forum.
Apologies if my message sounds harsh, but sometimes harsh is what you need to hear...
I don't know what got into you. Firstly, I am not venting out my frustration; I am just trying to draw attention. Secondly, I am aware that people are not getting paid. Thirdly, I would have really appreciated it if you could have looked at the data and suggested something to me. The title may be a little vague, but I believe I have tried to explain my requirements clearly.
Apologies if my message sounds blunt, but sometimes being blunt is subtle.
I really don't understand your question. Try asking it in a different way, with more specifics. I don't even understand if you are talking about loading the data table into Qlik or formatting a Table chart in the layout, and what your problems are. Your message doesn't contain as specific question that anyone could answer - and that is why you haven't seen any responses. Try to be more specific.
I am attempting to accomplish two things here. Firstly, I want to load the tables in the script editor and establish proper links between all the tables. Secondly, I am aiming to achieve the visualization depicted in the link above.
I am attaching two tables with this email, namely "Characteristics" and "Covid 19 surveillance all data.1st." These tables do not have a common field, so I am unable to link them using the load editor. I have tried using "apply map" and "generic load" to change the dimensions of the "Characteristics" table to match the "Covid 19 surveillance all data.1st," but it did not work out. Therefore, I need assistance with this.
For the visualization part, it would be best if you could check the link that I provided for a better understanding. Explaining it further with words might complicate things. So, please take a look at the link.
So, it looks like the main problem is to link between the two tables on the Age Group, which is called differently in two tables? We do it by renaming one or both of the fields to a common name, like this:
Table1:
LOAD
...
[Age Group] as Age,
...
;
Table2:
LOAD
[Common Strata 1] as Age,
...
Now the two tables will be linked by Age. The rest is just aggregating the numbers appropriately and showing them in a line chart.
Only if it is so easy. Even, if I rename of the field as AGE, it will not work because Primary StrataSecondary Strata fields from Characteristics tables have multiple dimension and Primary Strata Name and Secondary Strata Name fields shows the corresponding values.
For eg, Primary Strata has age first then sex then race/ehtnicity then month then ICU then Mechanical Ventilator and finally In hospital death. Primary Strata name shows the value.
Same for Secondray strata name and secondary starta name. How to make this table with fields :
AgeGrp Sex Race/Ethnicity Medical conditions Month
A table with 5 fields. Medical conditions has 20 different values.
