Help required to build the expression when there is no selection.

[qlikviewforum]

We have a expression in the straight(No dimension) table which work when selection are done. The selection are such as State and City Now the user wants to see similar expression in a straight table but this time user will select only the state and the chart should display the value for respective city. In the new straight table dimension are State and City. But it is some how working. Could you please help

sum({<$(e_DateRange),

CUSTID = {"=rank(sum({<[Client]-={'NA'},$(e_DateRange)>} Sales))<=$(vRank)"}>} Sales)

/

sum(Total {< $(e_DateRange) >} Sales)

[Anonymous]

Are you talking about adhoc reporting?

Adhoc reporting in Qlikview

[Peter_Cammaert]

If it is all "some how working", it isn't entirely clear what we should help you with. Can you provide a more detailed question please? Thanks

Peter

[qlikviewforum]

Above expressions works when we select State and City. We want the same expression to work when we dont select the city. i,e when we select City it should the correct value for all the city for corresponding State. Hope it is clear now.

[Peter_Cammaert]

I think it would be better if you could post an example document (optionally with reduced data) in this thread. Gives us a chance to investigate your expression in the proper context. Would that be possible?

Peter