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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
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?