Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
subbareddykm
Creator II
Creator II

All values should be show

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?

1 Solution

Accepted Solutions
tyagishaila
Specialist
Specialist

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.

View solution in original post

2 Replies
subbareddykm
Creator II
Creator II
Author

Sample Output for Month =1 is

 

GroupSerial NameSUm(Value)
ASerial 1263
ASerial 4281
BSerial 7299
BSerial 10317
CSerial 13335
CSerial 16353
ASerial 20
ASerial 50
BSerial 80
CSerial 110
CSerial 140
CSerial 170
ASerial 30
ASerial 60
BSerial 90
CSerial 120
CSerial 150
CSerial 180
tyagishaila
Specialist
Specialist

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.

View solution in original post