Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Unable to query where data

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?

1 Solution

Accepted Solutions

Re: Unable to query where data

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

7 Replies

Re: Unable to query where data

What is the Format of your period_end?

Re: Unable to query where data

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.


talk is cheap, supply exceeds demand

Re: Unable to query where data

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

Not applicable

Re: Unable to query where data

period_end is a timestamp without timezone in a postgres db

Not applicable

Re: Unable to query where data

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?

Not applicable

Re: Unable to query where data

Thanks the format had changed when importing data.

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

Re: Unable to query where data

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


talk is cheap, supply exceeds demand