topic Selection of data in QlikView

Selection of data

Thu, 25 Apr 2013 11:57:55 GMT

Hello

i need help with selecting data.

I need data from field AcAm filtered by AcNo >=3000 <=3999 AND ValDT <= variableDate

I tryed this, but i seams that the variable not work.

sum( {$<AcNo= {'>=3000<=3999'},ValDT= {'<=$(vMyLastDateOg Month_N)'}>} AcAm)

Is it something wrong with tis expression?

//Gunnar

Re: Selection of data

giakoum — Thu, 25 Apr 2013 12:06:36 GMT

Actually it looks ok.Try replacing the single quotes with double quotes. Otherwise please post same sample report,

Did you check that the variable is in the correct date format? Try with a fixed value first.

Re: Selection of data

kumarnatarajan — Thu, 25 Apr 2013 12:16:13 GMT

Hi,

Check the your variable format and ValDT format

And Remove the (vMyLastDateOg Month_N) variable space.

Re: Selection of data

shree909 — Thu, 25 Apr 2013 21:39:56 GMT

Hi,

The expression looks good but u need to find out the value of this variable $(vMyLastDateOg Month_N) if its mathing with the ValDT or r eplace thevariable with the value and try it , the varaible value should exactly match with the ValDT values then only the expression works

or Try this
sum( {$<AcNo= {'>=3000<=3999'},ValDT= {'<=$(=vMyLastDateOg Month_N)'}>} AcAm)

Re: Selection of data

Mon, 29 Apr 2013 06:24:32 GMT

I found the problem. I have wrote ValDT as a field name, it should be ValDt.

I was not aware that it had to be the case senitive

Tank'f for the hint

//Gunnar