topic Re: All values should be show in QlikView

All values should be show

subbareddykm — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I have below data

Sample:

LOAD * INLINE [

Group, Serial Name, Month, Value

A, Serial 1, 1, 263

A, Serial 2, 2, 269

A, Serial 3, 3, 275

A, Serial 4, 1, 281

A, Serial 5, 2, 287

A, Serial 6, 3, 293

B, Serial 7, 1, 299

B, Serial 8, 2, 305

B, Serial 9, 3, 311

B, Serial 10, 1, 317

C, Serial 11, 2, 323

C, Serial 12, 3, 329

C, Serial 13, 1, 335

C, Serial 14, 2, 341

C, Serial 15, 3, 347

C, Serial 16, 1, 353

C, Serial 17, 2, 359

C, Serial 18, 3, 365

];

I have a straight table, in that Group and serail name is my dimention and expression is Sum(Value).

My requirement is if i select any month it is giving respective groups and serial names its fine . But my user wants if he select any month available group and serial name 's value should be show and remaing we have to show as 0.

Can any one tell me how to achieve it?

Re: All values should be show

subbareddykm — Wed, 10 May 2017 04:17:44 GMT

Sample Output for Month =1 is

Group	Serial Name	SUm(Value)
A	Serial 1	263
A	Serial 4	281
B	Serial 7	299
B	Serial 10	317
C	Serial 13	335
C	Serial 16	353
A	Serial 2	0
A	Serial 5	0
B	Serial 8	0
C	Serial 11	0
C	Serial 14	0
C	Serial 17	0
A	Serial 3	0
A	Serial 6	0
B	Serial 9	0
C	Serial 12	0
C	Serial 15	0
C	Serial 18	0

Re: All values should be show

tyagishaila — Wed, 10 May 2017 04:30:12 GMT

Fiind attached qvw,Hope it will help you.

Add 1 more colum in expression tab, and by pass all dimensions

Sum({<Group=,Month=, [Serial Name]= >}1)

now go to presentation tab & hide this column.