Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
emteam162
Creator
Creator

Display value at simple table

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

Dim1dim 2date1date2date3date4date5date6
112301/03/201216/04/201202/05/201203/05/2012 -04/05/2012
212401/03/201201/03/201202/05/2012---
312501/03/2012-02/05/2012-02/05/201202/05/2012
412601/03/2012-02/05/201202/05/2012--
512701/03/2012-02/05/201202/05/201202/05/201202/05/2012
612801/03/201202/05/201202/05/201202/05/201202/05/2012
812901/03/201202/05/201202/05/201202/05/201202/05/2012
913001/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

Dim1dim 2date1date2date3date4date5date6
112301/03/2012--- --
212401/03/2012-----
312501/03/2012-----

any idea please

best regards

emteam

4 Replies
MayilVahanan

HI

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

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
emteam162
Creator
Creator
Author

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

Dim1dim ##########2if condition then dat1if condition then date2if condition then date3if condition then date4if condition then date5if condition then date6
112301/03/201201/03/201201/03/2012---
212401/03/2012-01/03/201201/03/2012-01/03/2012
312501/03/201201/03/201201/03/201201/03/2012--

i don't want suppress value null.

Thanks

MayilVahanan

HI

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

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
emteam162
Creator
Creator
Author

Hi,

Please, can you attache a sample example?

Many thanks