topic Data Fields Drop-Down Grouping Challenge in QlikView

Data Fields Drop-Down Grouping Challenge

Mon, 18 Mar 2013 10:49:52 GMT

I have a problem that I am not able to address for quite some time now. I have named this problem as – Data Fields Drop-Down Grouping Challenge.

Background: I have 12 data fields (all of them in single table- excel sheet) – P1, P2, P3 , P4, C1, C2, C3, C4, M1, M2, M3, M4

P - Population, C - Companies and M – Money

Challenge: Now I have to create a bar graph in such a way that there is a drop down box right above the bar graph and the drop down contains following option- Population, Companies and Money. When I select ‘Population’ option from the drop down box then the bar graph should show only P1, P2, P3, P4 (population data fields) on the graph. When I select ‘Companies’ option in the down-down then the graph should only show C1, C2, C3, C4 (companies data fields). And when I select ‘Money’ option then only the M1, M2, M3, M4 ( money data fields) should be displayed on the bar graph.

Will it be possible if anyone can suggest step by step method to get this type of grouping.

Re: Data Fields Drop-Down Grouping Challenge

Mon, 18 Mar 2013 11:11:48 GMT

By using Cross table method you can find solution.

First:

Create 3 table instead of 1 table using resident method. first table fields are P1,P2.P3,P4,Type. Second table fields are C1,C2,C3,C4,Type. Third Table fields are M1,M2,M3,M4,Type

In field "Type" give proper value based on table like 'Population','Companies' and 'Money'.

Now all 3 table into final qvw.. You can use "Type" field as list box.

Hope its will help u..

Re: Data Fields Drop-Down Grouping Challenge

Mon, 18 Mar 2013 11:15:17 GMT

Sorry I forgot to mention main step..

Using cross table convert all columns like P1,P2,P3,P4 into row... Keep this field name same for all 3 tables.

If you can't understand this method.. Kindly post sample data..

Re: Data Fields Drop-Down Grouping Challenge

flipside — Mon, 18 Mar 2013 11:27:49 GMT

If you are using QV11, then you can do the following ...

1. Create an island table with one field (eg DataGroup) in script to hold your Group names (Companies, Money and Population) and create a list box.

2. Add ALL your expressions to your single bar chart.

3. Tick the conditional show box for each expression and add =Only(DataGroup)='Companies' (or Money or Population as releveant).

Your chart should show the relevant expressions as the user selects the group. You can even change the 'All expressions disabled' message on the General tab in properties to a more user-friendly message such as 'Please select a Data Group' or something.

flipside