topic Set Analysis Issue in QlikView

Set Analysis Issue

Thu, 23 May 2013 18:29:01 GMT

I have the following formula in Expression :

sum(price)/sum(total{<user, region>})price)

This works if In Qlikview I have a value on the price column selected. ( I have the percentage selected in the Number tab )

But as soon as I uncheck the value in the price column the expression becomes 0.

any suggestions pls.

Thanks

Re: Set Analysis Issue

Gysbert_Wassenaar — Thu, 23 May 2013 18:50:03 GMT

It's pretty amazing it returns anything at all. The parentheses don't match up.

sum(price)/sum(total{<user, region>})price)

And {<user, region>} doesn't do anything. Maybe you mean sum(price)/sum(total <user,region> price). If not you'll have to explain what you want. Start with your showing some source data and then show what the result table should look like.

Re: Set Analysis Issue

Thu, 23 May 2013 19:09:15 GMT

Thanks a lot.

Removing the {} from the expression resolved the issue.

So now I have columns looking like ( In a pivot table )

User Price Fruits Expression

here expression has the percentage of each fruit for this specific user.

for this the formula used is :

sum(price)/sum(total<user, fruits>price)

this works.

Now is it possible to sort this based value in the expression ? High to low ?

Re: Set Analysis Issue

Thu, 23 May 2013 19:09:43 GMT

Thanks a lot.

Removing the {} from the expression resolved the issue.

So now I have columns looking like ( In a pivot table )

User Price Fruits Expression

here expression has the percentage of each fruit for this specific user.

for this the formula used is :

sum(price)/sum(total<user, fruits>price)

this works.

Now is it possible to sort this based value in the expression ? High to low ?

Re: Set Analysis Issue

Thu, 23 May 2013 19:10:10 GMT

Thanks a lot.

Removing the {} from the expression resolved the issue.

So now I have columns looking like ( In a pivot table )

User Price Fruits Expression

here expression has the percentage of each fruit for this specific user.

for this the formula used is :

sum(price)/sum(total<user, fruits>price)

this works.

Now is it possible to sort this based value in the expression ? High to low ?

Re: Set Analysis Issue

Gysbert_Wassenaar — Thu, 23 May 2013 19:12:57 GMT

Pivot tables are somewhat picky when it comes to sorting. You can try setting the sort option of the first dimension to sort by Y-value. That should sort the pivot table using the values of the first expression.

Re: Set Analysis Issue

Thu, 23 May 2013 19:35:40 GMT

Thank you again.

How would I do it if this was a straight table ?

Re: Set Analysis Issue

Gysbert_Wassenaar — Thu, 23 May 2013 19:39:15 GMT

Move the expression to the top of the sort priority list on the Sort tab of the properties window.

Re: Set Analysis Issue

Thu, 23 May 2013 19:45:35 GMT

Thank you very much.

It worked.