How to solve this issue

[#1]

Hi All,

I have questions and answers 1 to 13.

i have to display Y if the answer is 1 or N if the answer is 0 or N/A if the answer is -1. and Percentage as sum over count as below

and % of change is comparison with previous year.

Now with Qlikview, i am able get the output as below with two tables. it is possible get the result in single table.

Please help me on this. I have attached the QV file here.

Thanks,
Selva

[#2 · Accepted solution]

Hi,

Please find the attached application.

But it is suitable if the Mystery Shoppers are few.

[marcus_sommer]

Your approach to use two objects for a single request is very common and if you overlapped both objects and make appropriate settings for object-visibilties and object-properties (colors with aggr(0,0,0,0) for transparence and so on) it could look like a single object.

Both tables in a single object would only work if you replaced the dimension Mysterie_Shopper with several expressions one for each dimension-value - then you could merge these table with the expressions from the other table.

By the way I would suggest to simplify your expressions by doing some preparations within the script, for example:

- creating the string-value for the answers in an additional field

- creating a mapping-table for questions-descriptions

- categorizing from the questions (Q1 - Q13 = current, else = other) and it could be easily selected

- Marcus

[#4]

Thank you Marcus for your time and support.

[#5]

Hi All,

I have a table in Qlikview as below. I changed the text color to white in the total row for MS1 to MS5.

Exporting the report to pdf format displays the values in total column. how can i control this. Please help.

Thanks,
Selva