Unable to query where data

[#1]

I am currently trying to produce a line graph based on data where certain data equals a value. In short I want to perform the equivalent of a WHERE query on my loaded data.

I have tried Sum ({$<[period_end]={'2014-08-31 01:00:00'}>} string_value) but it does not seem to work.

Any ideas?

[MK_QSL]

What is the Format of your period_end?

[Gysbert_Wassenaar]

period_end has to be a field, not an expression and not a calculated dimension.

Make sure that the field period_end contains date values in the format YYYY-MM-DD hh:mm:ss or text values.

Make sure the field string_value contains numbers that can be summed. Summing text values will not work unless you use the num#() function to turn the strings into numbers.

Make sure to use the exact case-sensitive field names. Period_End and period_end are two different things to QV.

[alexandros17 · Accepted solution]

the format of period end field is different from what you have written on the right side ...

add your period end field in a table and loot at the format

[#5]

period_end is a timestamp without timezone in a postgres db

[#6]

Thank you. The timestamp has changed format from the db when imported in to qlik. Any idea why and how I can change the format?

[#7]

Thanks the format had changed when importing data.

Out of interest how do I implement the num#() function to turn the strings into numbers?

[Gysbert_Wassenaar]

1. Open Qlikview Desktop

2. Press F1 to open the help file

3. Click on the Index tab

4. Enter num# in the input control and press the enter key

5. Read the help file text for the num# function