topic Re: Value is not showing at set analysis in QlikView

Value is not showing at set analysis

Tue, 12 Aug 2014 07:44:28 GMT

Hello Everyone,

Can you please help in this

i used set like below, expression is ok, but not getting any values

=sum({<Year_No={$(vYear)},Manager={'Harsha'}>}[Revenue])

any one please correct me if i wrote wrong syntax

Thanks

Re: Value is not showing at set analysis

amit_saini — Tue, 12 Aug 2014 07:48:08 GMT

Try this:

=sum({<Year_No={$(vYear)},Manager={'Harsha'}>}Revenue)

Thanks,
AS

Re: Value is not showing at set analysis

Tue, 12 Aug 2014 07:53:40 GMT

Still not getting the value

Re: Value is not showing at set analysis

Miguel_Angel_Baeyens — Tue, 12 Aug 2014 07:57:00 GMT

Hi,

Are the contents of field Year_No and variable vYear the same?

Does vYear store a function or just a literal?

Do you have any selections that may avoid that expression to return values?

Miguel

Re: Value is not showing at set analysis

amit_saini — Tue, 12 Aug 2014 07:58:55 GMT

Please share your application.

Thanks,

Re: Value is not showing at set analysis

sibideepak — Tue, 12 Aug 2014 09:02:04 GMT

Hi Sreeharsha V

Have you tried this one ,

=sum({<Year_No={$(=vYear)},Manager={'Harsha'}>}[Revenue])

Thanks

Deepak

Re: Value is not showing at set analysis

sudeepkm — Tue, 12 Aug 2014 09:17:38 GMT

when you say that you are not getting values can you please let us know if you are seeing a zero as result or you are seeing just a "-".

Also you may check if the selection combination in your set analysis has data present or not. that means for Manager name "Harsha" please check if you have data present for the selected years.

Can you please post the screenshot of the variable and expressions ?

Re: Value is not showing at set analysis

vardhancse — Tue, 12 Aug 2014 09:32:34 GMT

Try,

sum({$<Year_No={'vYear'},Manager={'Harsha'}>}[Revenue])

Re: Value is not showing at set analysis

Tue, 12 Aug 2014 10:54:28 GMT

Sorry Not working

Re: Value is not showing at set analysis

Tue, 12 Aug 2014 10:54:44 GMT

I am getting zero value

Re: Value is not showing at set analysis

Tue, 12 Aug 2014 10:56:14 GMT

Not working sorry

Re: Value is not showing at set analysis

jagan — Tue, 12 Aug 2014 11:02:50 GMT

Hi,

Check the variable vYear value by putting in Text Object and check whether you have data for the variable value. Try below expressions

=sum({<Year_No={$(=vYear)},Manager={'Harsha'}>}[Revenue])

=sum({<Year_No={'$(=vYear)'},Manager={'Harsha'}>}[Revenue])

Regards,

Jagan.

Re: Value is not showing at set analysis

sudeepkm — Tue, 12 Aug 2014 11:02:56 GMT

if possible then can you pls post the qvw ?

Re: Value is not showing at set analysis

rubenmarin — Tue, 12 Aug 2014 11:05:44 GMT

Maybe you need to check values before continue:

- in a text box check the return for =vYear

- in a straight table with dimensions Manager and Year_No the expression Sum([Revenue])

Select manager Harsha and check the revenue when Year_No=vYear

Re: Value is not showing at set analysis

Tue, 12 Aug 2014 11:08:19 GMT

i can't post the qvw, since it is huge and having client information

Re: Value is not showing at set analysis

Tue, 12 Aug 2014 11:09:04 GMT

values are there i checked it, association also there between

Re: Value is not showing at set analysis

Tue, 12 Aug 2014 11:31:24 GMT

Hi,

Try, sum({$<Year_No={$(#vYear)},Manager={'Harsha'}>}[Revenue])

Re: Value is not showing at set analysis

sudeepkm — Tue, 12 Aug 2014 11:32:10 GMT

then it should have worked unless there are some spelling mistakes.

Can you please post screenshot of your chart and tell us what you see in the expression? like below.

do you see any value for Year_No in your chart. like in the attached screenshot the value is 2012.