Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Create chart

Hi all,

I have 3 variables (Platinum, Gold and Club) with answers Yes or No.

Is it possible to create chart with 3 variables (only who said Yes) in dimension and expression for them?

Or your other issues.

I created this chart with 1 variable (consist all 3 variables), but sometimes they have answers at the same time (Yes). And my chart shows wrong results, because I have different sample size.

Please find attached the file.

If you have any questions , ask me.

Thanks in advance,

5 Replies
sbaldwin
Partner - Creator III
Partner - Creator III

Hi have you tried changing the format of your daa, something like this?

Thanks

Steve

Anonymous
Not applicable
Author

Hi,

Thank you for your help.

I tryed your file and applyed to my file.

But I got multiplied sample size ( maybe I did wrong something) and result in chart should be 100% for each.

My current file has ID and other variables.

I take my data from SQL. Then I load

New:

noconcatenate load 'Platinum' as Attribute ,  Platinum as Response,* resident OLD;

concatenate(New) load 'Gold' as Attribute ,  Gold as Response,* resident OLD;

concatenate(New) load 'Club' as Attribute ,  Club as Response, * resident OLD;

DROP  Table OLD;

Anonymous
Not applicable
Author

Please find my file. and fix selection for a chart.

If you have questions, please ask me.

Thanks,

Anonymous
Not applicable
Author

Any thought?

Anonymous
Not applicable
Author

any ideas?