Set Analysis Issue

[#1]

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

[Gysbert_Wassenaar]

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.

[#3]

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 ?

[#4]

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 ?

[#5]

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 ?

[Gysbert_Wassenaar]

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.

[#7]

Thank you again.

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

[Gysbert_Wassenaar]

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

[#9]

Thank you very much.

It worked.