topic SYNTAX HELP in QlikView

SYNTAX HELP

Mon, 10 May 2010 07:16:20 GMT

Hey people,

i am new to Qlikview, getting confused with syntax in writing a simple expressions. Can anybody help me with this?

i want to to have a field in pivot with expression (count of cells with value greater than 1)

hope i made my problem clear...

HARNEET

SYNTAX HELP

Mon, 10 May 2010 07:23:09 GMT

Hi Harnnet,

Please explain your question well. What actually is you problem...

Thanks

Joseph

SYNTAX HELP

spsrk_84 — Mon, 10 May 2010 07:28:30 GMT

Hi,

U can write like this

Count( if ( CellValue>1, Noofcells)

Likethis also

If( CellValue>1,Count(NoofCells)

First expression is the best one ...........

Regards,

Ajay

SYNTAX HELP

Mon, 10 May 2010 07:43:22 GMT

Hey Joseph,

I have Zone, regions in my data set. what I am trying to to is adding a field in pivot where i can show that a particlar regions have lets say 10 number of services. basically it is the count of services with value greater than 1 for a region. i am using this exp -- Count(if([Service Cost]>1, [service cost])

HARNEET

SYNTAX HELP

Mon, 10 May 2010 09:20:53 GMT

Hi Harneet

What is going wrong then? Your formula (maybe a typo only) lacks a closing bracket.

Formulas returning null should be checked for proper syntax first.

Jürg

SYNTAX HELP

Mon, 10 May 2010 10:12:22 GMT

Thanks Joseph, Ajay, Jurg,

I got what i was looking for.. just wanted to confirm with you guys if the problem was same what i thought it is...

in expression - Count(if([Service Cost]>1, [service cost])) what i did wrong was service cost (second time) in small letter. Do we really need to take this thing into consideration when writing an expression in Qlikvew??

SYNTAX HELP

Mon, 10 May 2010 10:13:05 GMT

Thanks Joseph, Ajay, Jurg,

I got what i was looking for.. just wanted to confirm with you guys if the problem was same what i thought it is...

SYNTAX HELP

Mon, 10 May 2010 10:28:12 GMT

QlikView fields are case sensitive, no way around this.

When typing your expressions the green color will show you that the field is spelled and cased correctly