topic Re: Plotting a chart in QlikView

Plotting a chart

Mon, 16 Sep 2013 05:12:28 GMT

Hi everyone,

I am facing a weird problem.

I have three fields:Meter No,Date and Power.

I am trying to plot a graph of Meter No v/s Power.

When I select a meter for a particular date,corresponding values get selected in Power listbox.

However,the graph shows a blank.

Please help

Thanks

Asmita

Re: Plotting a chart

Mon, 16 Sep 2013 05:27:31 GMT

Try to transform your plot chart to Straight table and check if your selection in date returns any data for Meter No or Power.

Re: Plotting a chart

Mon, 16 Sep 2013 05:46:29 GMT

All the fields are showing a blank

Re: Plotting a chart

Mon, 16 Sep 2013 06:32:27 GMT

Than problem is most probably in expression. Could you post it? Or maybe your calendar isn't correctly connected to fact table where are fields for Meter No/Power, check data model.

Re: Plotting a chart

Mon, 16 Sep 2013 06:34:33 GMT

Can you post a sample app with small data

Re: Plotting a chart

Mon, 16 Sep 2013 07:11:49 GMT

how to upload sample app

Re: Plotting a chart

Mon, 16 Sep 2013 07:16:53 GMT

When you click on Reply>In right upper corner is 'Use Advanced editor' and than in that window will be in right below corner 'Attach'. Don't know why it's so complicated.

Re: Re: Plotting a chart

Mon, 16 Sep 2013 09:55:29 GMT

I have attached a sample file .

Re: Plotting a chart

Mon, 16 Sep 2013 09:59:33 GMT

Hi Asmita,

Instead of using "Only (KWH_FWD) " use "=SUM (KWH_FWD) " in the expression.

PFA.

Hope this helps!

Re: Plotting a chart

Mon, 16 Sep 2013 10:29:06 GMT

Thanks Dusan and Shyamal.

It worked.