Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
lejours88
Creator
Creator

Show dimension that has null value

Hi I have a question,

I want to show all Brand in my data although it doesn't have any values.

I have 3 brands --> D123, D125, and D127.

The only brand that has value is only D123.

But i want to Show all brand, D123, D125, and D127 on my pivot table.


I have try using show all values in brand dimension. But i have brand's group, group A and group B. When i choose Group A i want to show only Brand D123, and when i choose group B i want to show brand D125 and D127.


I also attach my sample data and file.



Really appreciate your help.

Thanks in advance.

5 Replies
sunny_talwar

I am confused, first you said you want to see all values for the three brands even if they don't have value and later you said you only want to see those brands which has value. What exactly do you want? Expected Output?

lejours88
Creator
Creator
Author

Hi Sunny,

Sorry for the unclear statement.

If i'm choosing group A i want to show all Brand in Group A although it doesn't has any value.

And if i'm choosing group B i want to show all Brand in Group B including Brand with null value.

Is it clear enough Sunny ?

For example I have a data like this:

AreaInvYearweekAreaIDDescriptionBrandQtyGroup
New YorkBig2016011Big InvD1235A
D125B
D127B
D129A

So when i choose Group A, the result i expected is the pivot table show Brand D123 and D129 although D129 doesnt has any value (null Value) . I use sum(Qty) in my expression.

Thanks

sunny_talwar

This?

Capture.PNG

lejours88
Creator
Creator
Author

Hi Sunny,

Yes nearly like that. But, is it possible to hide the second row with "-" Description ?

Thanks in advance

sunny_talwar

May be this:

Capture.PNG