This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
This is my scenario. its a pivot table
country - USA UK CHI ESP CSB KOL
basically all the products has to be shown but I need to limit the countries only to UK and USA. My problem is if I apply an filter on the countries .. certain product gets removed. I would like to keep the product as well and show that it is 0.
country - USA UK
product 0 0
bulbs 100 10
capacitora 0 10
For your product dimension tick the Show All Values option.
Go to presentation tab, and try this...
Dimensions Tab -> Check Show All Values
Presentation Tab -> Uncheck Suppress Zero-Values ,Null Symbol -> 0 and Missing Symbol -> 0
no its not working. basically iam using a match condition to filter the countries while loading.. is their any other way to filter?
Can you please share your QVW file please?
Hi, Can you please share dummy data if possible.
Hi Please find the dummy data with qvw
you can load all your data without limit in the script. you can restrict it in front end using set analysis
check the attachment. may be helps.