topic Re: Show some fields in scatter chart in QlikView

Show some fields in scatter chart

Anonymous — Fri, 16 May 2014 15:15:06 GMT

Hi guys,

I have 4 different variables. I'd like to show them together in 1 chart.

Is it possible?

Please find my attached file.

Thanks,

Re: Show some fields in scatter chart

Fri, 16 May 2014 15:50:32 GMT

You don't have any stored variables, are you talking about putting 4 different dimensions into the same chart?

Re: Show some fields in scatter chart

SunilChauhan — Fri, 16 May 2014 15:50:46 GMT

set a variable on each button click with different name

and use in chart label expression

=vShow &' '&'Effectiveness'

see the attched file

hope this make sense

Re: Re: Show some fields in scatter chart

Anonymous — Fri, 16 May 2014 16:28:21 GMT

By default the chart should show all tags for these 4 variables

I need to show all tags for each variable, but code them by colors. (in chart)

Like Channel should be green, Campaign -red, Organic search - yellow, Paid Search - blue.

Legend should be only Channel, Campaign, ... (legend)

Please find my sample file.

I combined only 2 variable

Re: Show some fields in scatter chart

Anonymous — Fri, 16 May 2014 19:04:35 GMT

Maybe crosstable helps???

Re: Show some fields in scatter chart

Anonymous — Tue, 20 May 2014 14:39:38 GMT

I'd like to have a chart, which shows all tags. The legend can be an image

Re: Show some fields in scatter chart

Anonymous — Mon, 26 May 2014 14:39:14 GMT

I resolved the issue.

I used crosstable command.

[Acquisition Landscape]:

CrossTable (Acquisition_Landscape,BBB)

LOAD respondentID,

[Channel] as "Channel ",

[Campaign] as "Campaign ",

[Keyword] as "Keyword "

// [Paid Keyword] as "Paid Search ",

// [Organic Keyword] as "Organic Search "

Resident File;

How to add dynamically legend in pop labels?

Thanks,

Re: Re: Show some fields in scatter chart

Anonymous — Tue, 27 May 2014 15:31:05 GMT

I was asked to add Search box for my chart.

I'd like to hide all bubbles, except of my wild search.

What should I change in my expressions?

Thanks,