topic How to solve this issue in QlikView

How to solve this issue

Thu, 07 Aug 2014 13:28:29 GMT

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

Re: How to solve this issue

Thu, 07 Aug 2014 14:09:29 GMT

Hi,

Please find the attached application.

But it is suitable if the Mystery Shoppers are few.

Re: How to solve this issue

marcus_sommer — Thu, 07 Aug 2014 14:26:20 GMT

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

Re: How to solve this issue

Sun, 10 Aug 2014 05:18:47 GMT

Thank you Marcus for your time and support.

Re: How to solve this issue

Mon, 11 Aug 2014 09:48:22 GMT

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