topic Set Analysis,Variable and Dimensionality in QlikView

Set Analysis,Variable and Dimensionality

Sun, 25 Sep 2011 12:45:02 GMT

Hi,

I have created variables as

Sales as sum({$<Type ={'Domestic'} >} sales)

And I have loaded in to the variables through the load script.

And i am trying to use this as expression in the Pivot table as below

= If( Dimensionality()=1, Pname='A' ,$(=Sales),'NA')

It is not showing any values how ever if i am trying to call the variable in the list box. It is showing the correct value.

$(=Sales)

Also when i tried to dimensionality in the set analaysis. i am getting the error.

sum({$<Dimensionality()=1,Type ={'Domestic'} >} sales)

Anyone has faced the similar issues?

lironbaram — Sun, 25 Sep 2011 12:55:55 GMT

hei

i think you sintax error in your first expression it should be

= If( Dimensionality()=1 AND Pname='A' ,$(=Sales),'NA')

as for tring to use dimensionality in set analysis you cant as set analysis is to make selection

hope its helps you

Sun, 25 Sep 2011 13:08:18 GMT

Hi,

I am not getting the value without using the dimensionality as well, i tried this way as well

= If( Pname='A' ,$(=Sales),'NA')

Any suggestions

lironbaram — Sun, 25 Sep 2011 13:31:27 GMT

try = If( Dimensionality()=1 AND Pname='A' ,$(Sales),'NA')

Sun, 25 Sep 2011 13:33:42 GMT

Can you post the qvw? That can help debugging better.

Regards,

Kiran

Sun, 25 Sep 2011 14:29:52 GMT

Thanks for all your responses ,

I have fixed it. It was data issue