Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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
What is the Format of your period_end?
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.
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
period_end is a timestamp without timezone in a postgres db
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?
Thanks the format had changed when importing data.
Out of interest how do I implement the num#() function to turn the strings into numbers?
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