Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Not applicable

Show all values in a dimension

Hi All,

I have a requirement to show all countries by month in a pivot with month running horizontally and country vertically. When the user changes the month, the dimension country is reduced to show only countries that have a value and everything else is a null.

I have tried setting to not suppress nulls, but this doesnt work, i have tried to show all values but this does not work

If a create a listbox and write this expression concat(DISTINCT {1}country,',') then irrespective of selections I can see all countries. This expression does not give the same output as a dimension and actually populates nothing.

So how do i get the concat string function output in a listbox to work in a dmension on a pivot table

Your help is much appreciated

Kind Regards,

Byron

1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Re: Show all values in a dimension

See attached qvw.


talk is cheap, supply exceeds demand
12 Replies
Not applicable

Re: Show all values in a dimension

just uncheck Supress Missing Values. in the presentation tab

er_mohit
Honored Contributor II

Re: Show all values in a dimension

in presentation tab uncheck supress Zero value

hope it helps

Not applicable

Re: Show all values in a dimension

Thank you both for your replies. Tried the above as well and still no luck

Not applicable

Re: Show all values in a dimension

Use maximum columns available with u in the chart as dimensions and then check.

thts not going to help u out but atleast u will knw whts the difference its making on the expression part to get the country dimension to get eliminated.

Not applicable

Re: Show all values in a dimension

Thank you for your suggestion mate. Unfortunately, the model is not my own and actually helping a friend out so don't have much visibility as to what his data set looks like. If we figure it out, I will update this post for future reference.

Closing it now

Cheers,

Byron

MVP & Luminary
MVP & Luminary

Re: Show all values in a dimension

See attached qvw.


talk is cheap, supply exceeds demand
Not applicable

Re: Show all values in a dimension

You are too good Gysbert !!!

Thank you very much!

Cheers,

Byron

Not applicable

Re: Show all values in a dimension

Hi Gysbert i'am with a similiar problem but in a chart can you take a look in my thread when possible?

Show Dimension and zeros even if no values

Thanks in advance.

Not applicable

Re: Show all values in a dimension

Very good - solved my problem - thanks