topic Re: two dimension Vs Two Expressions in QlikView

two dimension Vs Two Expressions

Tue, 24 May 2011 11:02:59 GMT

Hi,

I have two dimension's like actual year and estimated year as dimensions.Both counta,countb as their counts as expressions.But i was struggling to link accordingly since from three days.

By the way,I have used

=ValueList(actual_Year,Estimated_Year) as dimension and

=if(valueList('actual_year','estimated_year')='actual_year',counta,countb) as one expression
=if(valueList('actual_year','estimated_year')='estimated_year',countb,counta) as another expression also.but it is not giving desired results.

Does any one know the solution for this?Please provide me the clue to do this?

Thanks& Regards,

Sushma K

two dimension Vs Two Expressions

kaushiknsolanki — Tue, 24 May 2011 11:42:27 GMT

Hi,

I think you missed ' thin dimension.

Try

=ValueList('actual_Year','Estimated_Year') as dimension

Regards,

Kaushik Solanki

Re: two dimension Vs Two Expressions

Tue, 24 May 2011 12:20:43 GMT

Hi ,

Thanks for all your reply.

I am not aware of thin dimension .What it is?

By the way,there is no difference from Estimated /estimated (my typo mistake).

Regardless of it,please give me the clue to proceed?

Thanks & Regards,

Sushma

Re: two dimension Vs Two Expressions

erichshiino — Wed, 25 May 2011 03:51:41 GMT

I think that he only meant that you should use single quotes around the string in the definition of the dimension using value list, like this:

=ValueList('actual_Year','estimated_Year')

You should also be careful with the strings, because your if-statement will be case sensitive.

Hope it helps,

Erich

Re: two dimension Vs Two Expressions

Wed, 25 May 2011 09:24:15 GMT

we have to be clear on requirement,which are three things as follows:

on x-axis: year ( from two date fields)

on y-axis:count(*) ( different for actual_year & estimated_year)

Category: actual_year with red & estimated _year with blue as a column at the right side of the chart.

Re: two dimension Vs Two Expressions

Wed, 25 May 2011 09:43:14 GMT

Hi Erich,

I haven't typed any thing on that chart ,what ever the variables and function are there i used and pasted always for the dynamic variables.so,No mistakes as per the syntax.I verified and corrected that syntax errors immediately if any.

I have attached the actual requirement(but it is clubing the both results into one and taking it as it is for other bar also).In that picture,Selected year is a combination of actual_year & estimated_year.(union of both).

Thanks for all ur replies.

Thanks & Regards,

Sushma K

Re: two dimension Vs Two Expressions

Sun, 29 May 2011 12:33:02 GMT

hi all,

Thanks for posting the consulting services as an example ,after viewing it,i got clarification from all the respect.

Thanks a lot for spending your valueable suggestions.

Regards,

Sushma