[ASK] how to show every data without select any dimension ?

[#1]

Hello..

i have a chart with a dimension and an expression

but when i'm not selecting any field of dimension, the data won't show up

just like the picture below =

but when i select one of the MST_KURS_ID the data show up like the pic below :

FYI =

- dimension is TRANS_KURS_DATE, which is the date

- expression is (TRANS_KURS_HIGH-TRANS_KURS_LOW)

what i want is :

how to view all the data without selecting any MST_KURS_ID ?

many thx..

[#2]

Hi,

Maybe your expression need a clause "SUM ()".

"SUM((TRANS_KURS_HIGH-TRANS_KURS_LOW))"

[johnw]

Looks to me like someone added a calculation condition to the General tab, then clicked on Error Messages and entered a custom message for Calculation condition unfulfilled? If so, the way you "fix" it is to remove the calculation condition.

[#4]

@Eduardo

hello ed, it doesn't work

@John

Hello john, it's still the same when i remove the calculation condition in general tab

[#5]

[View:http://community.qlik.com/cfs-file.ashx/__key/CommunityServer.Discussions.Components.Files/11/7534.source-eh.rar:550:0]

hello..

i've attached the qvw file

i'm stuck here

when i'm trying to do with the other table, this problem doesn't show up

[brenner_martina · Accepted solution]

Good morning, kribo.alim,

You entered in General Condition Calculating: Not InNull(MST_KURS_ID) --> that means you have to select a MST_KURS_ID to show the line, delete this and you get you line shown!

[#7]

Hi, the condition to calculate is wrong.

The function isnull() return -1 for true and 0 for false. So you need to change this expression:

if (isnull(MST_KURS_ID) <> -1, true(), false())

sds.

[#8]

@Martina

Good mornin Martina

thx for ur help, it is really helping me a lot

@Eduardo

thx Ed..

it is also helping me