Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All,
I need to create a table in the below format in Qlikview and right now I am not able to do so:
Question | Percentage of YES | Percentage of NO | Percentage of undecided |
Question1 | 10% | 90% | 0% |
Question2 | 10% | 90% | 0% |
Question3 | 10% | 90% | 0% |
Question4 | 5% | 95% | 0% |
Question5 | 10% | 80% | 10% |
Question6 | 20% | 80% | 0% |
Question7 | 10% | 10% | 80% |
Question8 | 10% | 90% | 0% |
I am currently creating multiple tables in qlikview for each question as shown below:
Is there a way which I can create 1 table for all the questions?
Many Thanks,
Hasvine
I think you might be able to do what you want using a synthetic dimension (ValueList or ValueLoop), but how this can be achieved can only be possible once we have a feel of how your data looks like.
It is difficult to understand the relation between the sample data and the image? What exactly are you trying to do? May be provide an expected output for the sample data you have provided?
hi,
concatenate all the questions to one table.
$@M.
Basically I have like 16 Question and I need to create a table whereby all the questions are showing.as below: (my expected output)
However, in Qlikview I am not able to create a single table as my output shows.
I have to create an individual table for each questions and then create a report on excel manually by extracting all the data of each table.
As the question are not in a field I have to create them as my dimension for example:
And then I add my expressions:
Thank you for your help.
Kind Regards,
Hasvine
Can you show us the sample data with expected output?
I think you might be able to do what you want using a synthetic dimension (ValueList or ValueLoop), but how this can be achieved can only be possible once we have a feel of how your data looks like.
HI Sunny,
I checked the Valuelist function and I think that this is exactly what I need actually.
Thank you for your help.
Kind Regards,
Hasvine
Awesome, I am glad we were able to guide you in the right direction
As usual Sunny T to my rescue.
Thank you all for your help.
Kind Regards,
Hasvine