topic Re: Need Help in QlikView

Need Help

Sun, 15 Jun 2014 21:57:26 GMT

Hi Every body,

I am new to qlik view, I creatad the chart but is not getting displayed and it says no data to be displayed, but i am for sure that my steps are rite, could anybody tell me what might have happened?

Thank you

Re: Need Help

MK_QSL — Sun, 15 Jun 2014 21:58:04 GMT

Which Chart ?

What are the dimensions ?

What are the expression ?

Re: Need Help

Sun, 15 Jun 2014 22:10:32 GMT

Hi Manish,

I created the bar graph with

dimensions as year and measures as avg( price)

Re: Need Help

Clever_Anjos — Mon, 16 Jun 2014 00:39:48 GMT

Please upload your app, we have to check it

Re: Need Help

Mon, 16 Jun 2014 02:06:34 GMT

upload your document please.

Re: Need Help

Mon, 16 Jun 2014 02:50:07 GMT

Check whether your dimension is related to your expression. And for the further help, please upload one app(qvw) included your issue.

Re: Need Help

MK_QSL — Mon, 16 Jun 2014 07:49:25 GMT

Try below expression

Aggr(avg( price),Year)

Re: Need Help

Mon, 16 Jun 2014 10:39:17 GMT

Hi,

I have attached the file below, plz help.. dont know where i m going wrong..

STILL ITS SHOWING NO DATA TO BE DISPLAYED.

Thank you

Re: Re: Need Help

tresB — Mon, 16 Jun 2014 10:51:30 GMT

Your PRICE field is not numeric, rather string, hence the issue. I have used num#() to get it as numeric. You better take care of the same during load itself.

Re: Re: Need Help

Anonymous — Mon, 16 Jun 2014 11:01:59 GMT

hI,

Pls check this

Re: Re: Need Help

Mon, 16 Jun 2014 12:01:18 GMT

Hi,

Can you please explain where to use the num#() for the conversion.

sorry if the question is too silly.

Thank you

Re: Re: Need Help

Mon, 16 Jun 2014 12:01:56 GMT

Hi nIsha,

Can you please explain where to use the num#() for the conversion.

sorry if the question is too silly.

Thank you

Re: Re: Re: Need Help

Anonymous — Mon, 16 Jun 2014 12:08:51 GMT

Hi ,

Pls check this file. In this i have used num function

Re: Re: Re: Need Help

Mon, 16 Jun 2014 12:11:47 GMT

Hi nisha,

The document is not opening in my system ( Thats the main problem), or could you send the file to my mail id : geetha.kirupa@gmail.com

Re: Re: Re: Need Help

Anonymous — Mon, 16 Jun 2014 12:18:23 GMT

Hi,

I sent to ur mail id. Pls check your mail

Re: Re: Re: Need Help

Mon, 16 Jun 2014 12:19:03 GMT

Kirupakaran, you can do the sum() for a group of text value. It's the same with "A"+"B" + .... = ?. If you want to check whether the current calculated value is numeric or text. Right click on your List box of PRICE, see the alignment, by default, the text is on the left of list box, the numeric is on the right of list box. Always remember to transfer to num when calculating aggregation.

Re: Need Help

Tue, 17 Jun 2014 11:51:36 GMT

Hi everybody, ,

Thank you