topic Re: Re: show full data in straight table in QlikView

show full data in straight table

omid5ive — Sun, 15 Jun 2014 05:30:23 GMT

i have a straight table in my dashboard that should show the count of two thing for each office and it can be filterd by date.

when i chose some date, the straight will show the office that have value on their expessions, but i want to show all office.

for example when i chose year 2014 i want to see sth like this:

Office	Count(A)	Count(B)
100	10	20
200	12	15
300	10	0
400	0	0

but normaly straight shw sth like this:

office	Count(A)	Count(B)
100	10	20
200	12	15
300	10	0

because office number 400 have no value for both experssion

what should i do?

Re: show full data in straight table

ashfaq_haseeb — Sun, 15 Jun 2014 05:38:22 GMT

Hi,

May be like attached.

make sure you have below settings, images attached.

Regards

ASHFAQ

Re: show full data in straight table

MK_QSL — Sun, 15 Jun 2014 05:55:22 GMT

Dimension Tab

Select Suppress When Value is Null and Show All Values

Presentation Tab

Untick Suppress Zero Values

Re: show full data in straight table

omid5ive — Sun, 15 Jun 2014 06:06:37 GMT

sorry can you resend your first attachment? (capture2.JPG.jpg)

i cant download it

Re: Re: show full data in straight table

its_anandrjs — Sun, 15 Jun 2014 06:14:57 GMT

For suppress the Null values set properties >> Presentation >> Click on Check box for Suppress Zero-Values.

See the snap:-

Re: show full data in straight table

omid5ive — Sun, 15 Jun 2014 06:34:31 GMT

when i select some date it will just show the office that have values on that date

but i want to see sth like this when i select for example year 2014:

office Count(a) Count(b)

100 10 12

200 0 0

300 10 10

400 0 0

in normall situation qlik view will omit office 200 and 400 row because they dont have value on their expersion

Re: Re: show full data in straight table

ashfaq_haseeb — Sun, 15 Jun 2014 06:36:57 GMT

Attached.

Regards

ASHFAQ

Re: Re: show full data in straight table

ashfaq_haseeb — Sun, 15 Jun 2014 06:38:19 GMT

Hi,

Try by suggested solution.

If it does not work can you share your sample app?

Regards

ASHFAQ

Re: Re: show full data in straight table

omid5ive — Sun, 15 Jun 2014 07:08:20 GMT

thank you Ashfaq

it work correctly
thank for your guide

Re: Re: Re: show full data in straight table

omid5ive — Sun, 15 Jun 2014 11:11:19 GMT

hi again

what shoud i do if i want to have more than one dim?

i made some change on you attached document, if you download it you will see that i add another dimension (state) and a field (year)

when i select a year like 2014 you will see th like this replace "-" to office:

State	Office	Sum(A)
c	-	0
d	-	0
e	300	10
f	-	0

but i want to see this:

Header 1	Header 2	Header 1
c	100	0
d	200	0
e	300	10
f	400	0

do you know what should i do?

Re: Re: Re: Re: show full data in straight table

ashfaq_haseeb — Sun, 15 Jun 2014 11:19:03 GMT

Hi,

You need to replace null symbol with 0.

As shown in image attached.

Even application is attached.

Hope it helped.

Regards

ASHFAQ

Re: Re: Re: show full data in straight table

omid5ive — Sun, 15 Jun 2014 11:28:00 GMT

i want to see the office value not 0

Re: show full data in straight table

ashfaq_haseeb — Sun, 15 Jun 2014 11:28:13 GMT

Hi,

For that you need to have data at every grain.

For you same selection of 2014.

User below script.

load * Inline

[

state,Office,A,B,year

c,100,10,20,2012

c,100,0,0,2014

d,200,12,15,2013

d,200,0,0,2014

e,300,10,0,2014

f,400,0,0,2015

f,400,0,0,2014

];

Hope it helped.

Regards

ASHFAQ

Re: Re: Re: show full data in straight table

omid5ive — Sun, 15 Jun 2014 12:04:33 GMT

i think that is not a good solution

because i should genaret a lot of record on my DB

i should find tsome way to handle it from qlikview option not with quer

Re: show full data in straight table

ashfaq_haseeb — Sun, 15 Jun 2014 12:06:49 GMT

Hi,

If possible can you share your sample app.

To help you out here.

Regards

ASHFAQ