topic Re: Combine Fields as Dimension in QlikView

Combine Fields as Dimension

Fri, 05 Dec 2014 18:08:12 GMT

Let's say I have three fields: Country, Year and Sales

Here is my dataset

Key Country Year Sales

1 USA 2014 200

2 USA 2013 400

3 UK 2007 500

4 UK 2008 900

5 UK 2009 400

I want to create a chart where I show country and year as a dimension and sum(sales) as expression. However, I want to provide the user to chose what country and year combinations they want to display in the chart. Example: user wants to only show Keys 1,3,5 in the above dataset.

First I tried creating a combine field called CountryYear in the load process and use the combined field as a dimension. However, I don't like the presentation part of it (list box with the joint field). Is there a way I can have two list boxes Country and Year and use the joint field as a dimension.

Re: Combine Fields as Dimension

Anonymous — Fri, 05 Dec 2014 18:16:52 GMT

Yup.

Keep the Country and Year columns, and use in your 2 list boxes,

Add the new column of Country&Year combined, and use for you dimension

Re: Combine Fields as Dimension

its_anandrjs — Fri, 05 Dec 2014 18:27:58 GMT

Hi,

You can use different list box also by changing settings

List properties >> Presentation >> Selection Style override (And select LED Check boxes)

Regards

Anand

Re: Combine Fields as Dimension

Fri, 05 Dec 2014 18:46:55 GMT

I want the selections to be based on country and year, do you think it is possible?

Re: Combine Fields as Dimension

Anonymous — Fri, 05 Dec 2014 18:50:53 GMT

Sure is possible.

Have you tried it ?

If you have tried it & it did not work, then what kind not working ?

Re: Combine Fields as Dimension

Fri, 05 Dec 2014 18:50:57 GMT

Lets say there is the year 2007 for both USA and UK, if the user wants to show 2007 for only USA and 2009 for UK..could that be done?

Re: Combine Fields as Dimension

Fri, 05 Dec 2014 18:58:54 GMT

Yes I tried it and your suggestion as well. If a year is selected and the year does not exist for a particular country, I am unable to add that country to the chart for a different year.

Re: Combine Fields as Dimension

its_anandrjs — Fri, 05 Dec 2014 19:10:30 GMT

Yes you are right then in this condition due to association that country not selected because it is not exist for that years then it will not shown right. Or you can create the key as Bill suggest like

Country&Year as Key1

Key&Country&Year as Key2

Regards

Anand

Re: Combine Fields as Dimension

MarcoWedel — Sat, 06 Dec 2014 00:14:00 GMT

You could use alternate states to select independent country/year combinations.

hope this helps

regards

Marco