i want write a condition for 'purchases only in hyderbad'?

[#1]

pls  help me   to write condition for  purchases  only from  hyderbad

[simondachstr]

Use set analysis. For more information on that topic, please read the QlikView Reference Manual.

[senpradip007]

Try like:

Sum({<Location = {'Hyderabad'} >} [Purchase Amount])

[#4]

just give me  expression  for  this  scenario  pls

[SunilChauhan]

sum({<Fieldname='purchases  only from hyderbad'>} Amount)

[Anonymous]

Try like:

If(Location='Hyderabad',Sum(Purchase Amount))

Warm regards,

Venkata Sreekanth

[its_anandrjs]

What are the Dimension and Expression you have you can try like

Sum({<City ={'Hyderabad'}>} [Purchase Amt] )

Or

Sum({<CityCode ={'Hyd'}>} [Purchase Amt] )

Or

Sum({<Store ={'Hyderabad'}>} [Purchase Amt] )

[SunilChauhan]

Hi manoj

to avoid we can post unwanted thing please give more detail about requirement

its better post a sample

hope this helps

[#9]

i got it yar here after i will follow

[#10]

sum({<[field name]={'hyderabad'}>}purchase amount])