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

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

Thu, 05 Aug 2010 14:17:22 GMT

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..

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

Thu, 05 Aug 2010 14:36:46 GMT

Hi,

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

"SUM((TRANS_KURS_HIGH-TRANS_KURS_LOW))"

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

johnw — Thu, 05 Aug 2010 17:57:57 GMT

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.

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

Fri, 06 Aug 2010 03:19:24 GMT

@Eduardo

hello ed, it doesn't work

@John

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

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

Fri, 06 Aug 2010 03:22:30 GMT

[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

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

brenner_martina — Fri, 06 Aug 2010 07:56:05 GMT

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!

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

Fri, 06 Aug 2010 12:52:38 GMT

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.

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

Mon, 09 Aug 2010 02:40:25 GMT

@Martina

Good mornin Martina

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

@Eduardo

thx Ed..

it is also helping me