topic Re: Display value at simple table in QlikView

Display value at simple table

emteam162 — Mon, 22 Oct 2012 16:07:46 GMT

Hi,

I have one problem and i look a lot of the solve that but i can't

i explain i have one table with 10 column

Dim1	dim 2	date1	date2	date3	date4	date5	date6
1	123	01/03/2012	16/04/2012	02/05/2012	03/05/2012	-	04/05/2012
2	124	01/03/2012	01/03/2012	02/05/2012	-	-	-
3	125	01/03/2012	-	02/05/2012	-	02/05/2012	02/05/2012
4	126	01/03/2012	-	02/05/2012	02/05/2012	-	-
5	127	01/03/2012	-	02/05/2012	02/05/2012	02/05/2012	02/05/2012
6	128	01/03/2012		02/05/2012	02/05/2012	02/05/2012	02/05/2012
8	129	01/03/2012	02/05/2012	02/05/2012	02/05/2012		02/05/2012
9	130	01/03/2012	-	02/05/2012	-	02/05/2012

and i will combine the filtre

if condition then date1

if condition then date2

....

then when the first condition is ok then display only date1

Dim1	dim 2	date1	date2	date3	date4	date5	date6
1	123	01/03/2012	-	-	-	-	-
2	124	01/03/2012	-	-	-	-	-
3	125	01/03/2012	-	-	-	-	-

any idea please

best regards

emteam

MayilVahanan — Mon, 22 Oct 2012 16:15:16 GMT

Please tick the suppress when value is null in dimension tab

and

tick the Suppress zero value and suppress missing in presentation tab

Hope it helps

emteam162 — Mon, 22 Oct 2012 16:21:47 GMT

Hi,

Thanks for your replay.

Normaly i want the display all date if condition in experssion are ok

if condition is verifie then calcul if not most display date1 wiche associe with date2

Dim1	dim ##########2	if condition then dat1	if condition then date2	if condition then date3	if condition then date4	if condition then date5	if condition then date6
1	123	01/03/2012	01/03/2012	01/03/2012	-	-	-
2	124	01/03/2012	-	01/03/2012	01/03/2012	-	01/03/2012
3	125	01/03/2012	01/03/2012	01/03/2012	01/03/2012	-	-

i don't want suppress value null.

Thanks

MayilVahanan — Mon, 22 Oct 2012 16:35:10 GMT

Are you using qv-11?if so, use condition in expression tab..

if particular condition is satisfied, then will show the expression

Hope it helps

emteam162 — Mon, 22 Oct 2012 17:58:36 GMT

Hi,

Please, can you attache a sample example?

Many thanks