topic Re: Create chart in QlikView

Create chart

Anonymous — Wed, 11 Jan 2012 17:21:07 GMT

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,

Re: Create chart

sbaldwin — Thu, 12 Jan 2012 11:47:15 GMT

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

Thanks

Steve

Re: Create chart

Anonymous — Thu, 12 Jan 2012 15:29:40 GMT

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;

Re: Create chart

Anonymous — Thu, 12 Jan 2012 16:25:10 GMT

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

If you have questions, please ask me.

Thanks,

Re: Create chart

Anonymous — Mon, 30 Jan 2012 21:01:21 GMT

Any thought?

Re: Create chart

Anonymous — Thu, 09 Feb 2012 20:02:39 GMT

any ideas?