topic Re: Change line chart style interactively (remove dimension) in QlikView

Change line chart style interactively (remove dimension)

Sun, 04 Sep 2016 12:04:03 GMT

Hi all,

this is my data:

Country	Month	ItemsSold
1	Jan	12
1	Feb	15
1	Mar	17
1	Apr	3
1	May	17
1	Jun	18
2	Jan	15
2	Feb	17
2	Mar	19
2	Apr	16
2	May	18
2	Jun	12

I show this data in a line chart. Month and Country are the dimension, ItemsSold is displayed on the y axis (accumulated).

Now I am looking for a way to change the style of the line chart so that the country dimension is somehow removed and the ItemsSold of all countries get accumulated per month, e.g. for January, the values shown in the graph should be 27, instead of 12 and 15.

1. How can I define to accumulate per month?

2. Is there a way to let the user interactively switch between these two styles?

Thank you,

Christian

Re: Change line chart style interactively (remove dimension)

Anil_Babu_Samineni — Sun, 04 Sep 2016 15:53:04 GMT

PFA, and let me know your expected o/p?

Re: Change line chart style interactively (remove dimension)

Sun, 04 Sep 2016 19:01:05 GMT

Sorry, I can't open the attached file (QVPE). Can you please describe what to do or provide a link where it is explained how to implement the functionality described in my question?

Thank you

Re: Change line chart style interactively (remove dimension)

ecolomer — Sun, 04 Sep 2016 19:05:47 GMT

See this file

Is you need?

Re: Change line chart style interactively (remove dimension)

effinty2112 — Sun, 04 Sep 2016 21:51:41 GMT

Hi Christian,

You can remove and restore the country dimension easily to your chart. Make the dimension conditional on a variable, say vShowCountry. Create this variable in Variable Overview (via Settings) and set it equal to 1. In the Dimensions tab set the Enable condition for the Country dimension:

Add a button and set its text in the General tab:

Add an action to set the value of the vShowCountry variable:

That should do it. You should see something like:

Click the button and you should then see:

Kind regards

Andrew

Re: Change line chart style interactively (remove dimension)

Mon, 05 Sep 2016 18:26:33 GMT

Hi Andrew,

thank you, this is exactly what I need. I tried and it worked immediately with my data.

Now I have a bonus requirement:

I need to show the y-axis in relativ mode, i.e. 0-100%.

With the setting as in your example, the values add up to 100% when there is only one line, i.e. country is removed from dimension.

If there are separat lines for each country, each line only goes up to the percentage which reflects the ration of items sold in this country compared to the overall items sold.

Is there a way to scale each of the separat lines, so that every one of the goes up to 100%?

In fact, what I want to have is an empirical distribution function (Empirical distribution function - Wikipedia, the free encyclopedia), similar to what is shown in this picture (complete different data, just to show an example).

Thanks a lot,

Christian

Re: Change line chart style interactively (remove dimension)

effinty2112 — Tue, 06 Sep 2016 07:50:53 GMT

Christian,

Is this what your'e looking for? Use the expression given in the legend and in the expression tab select Full Accumulation. You can tidy it up a little by setting the Static Max to 1 in the Axes tab.

The TOTAL qualifier disregards any chart dimensions except any listed in the <>. In this case

Sum(TOTAL <Country> ItemsSold)

is a constant value for each month : the total number of Items sold in a country over all months. As the numerator accumulates to this figure for successive months the ratio approaches unity.

Regards

Andrew

Re: Change line chart style interactively (remove dimension)

Tue, 06 Sep 2016 17:56:09 GMT

Andrew,

yes, this is exactly what I need. I guess in the TOTAL <>, I can also use multiple columns, in case that my original second dimension is not only country, but country & product, or any other combination?

Thank you very much,

Christian

Country	Month	ItemsSold
1	Jan	12
1	Feb	15
1	Mar	17
1	Apr	3
1	May	17
1	Jun	18
2	Jan	15
2	Feb	17
2	Mar	19
2	Apr	16
2	May	18
2	Jun	12

Country	Month	ItemsSold
1	Jan	12
1	Feb	15
1	Mar	17
1	Apr	3
1	May	17
1	Jun	18
2	Jan	15
2	Feb	17
2	Mar	19
2	Apr	16
2	May	18
2	Jun	12

Country	Month	ItemsSold
1	Jan	12
1	Feb	15
1	Mar	17
1	Apr	3
1	May	17
1	Jun	18
2	Jan	15
2	Feb	17
2	Mar	19
2	Apr	16
2	May	18
2	Jun	12