topic Re: Dynamic cyclic group in QlikView

Dynamic cyclic group

mambi — Wed, 28 Oct 2015 10:40:30 GMT

Hi everyone,

as you can see in the image below , i want to use %dimensions as a cyclic group. but my problems is :

for exemple if i select 'Category' in the %dimensions listbox and the cyclic group is on 'Category' => the graph will display 100 % which make no sense.

so i want to remove dynamically from the cyclic group the item selected on the %dimensions list box.

any idea ?.

Re: Dynamic cyclic group

stephenedberkg — Wed, 28 Oct 2015 10:44:56 GMT

what is your expression in % calculation?

Re: Dynamic cyclic group

mambi — Wed, 28 Oct 2015 10:49:03 GMT

=if(%dimensions='Category',sum(Qt)/sum(TOTAL <Category> Qt),
if(%dimensions='Country',sum(Qt)/sum(TOTAL <Country> Qt),
if(%dimensions='Product',sum(Qt)/sum(TOTAL <Product> Qt)
)))

Re: Dynamic cyclic group

mambi — Wed, 28 Oct 2015 10:50:00 GMT

and here's my loading script :

table:
LOAD * INLINE [
     Category, Product, Country, Qt
     Sport, A, FR, 10
     Sport, B, DE, 9
     Sport, C, CA, 3
     Books, D, FR, 12
     Books, E, EN, 3
     Travel, F, CA, 4
     Clothes, G, FR, 7
];

NoConcatenate
%dims:
LOAD * Inline [
%dimensions
Category,
Product,
Country
]

Re: Dynamic cyclic group

avinashelite — Thu, 29 Oct 2015 11:30:31 GMT

I didn't get your exact requirement but as per your data

your expression is wrong , try like this

if(%dimensions='Category',sum(Qt)/sum(TOTAL Qt),
if(%dimensions='Country',sum(Qt)/sum(TOTAL Qt),
if(%dimensions='Product',sum(Qt)/sum(TOTAL Qt)
)))

Dynamic cyclic group

Re: Dynamic cyclic group

miguelbraga — Thu, 29 Oct 2015 11:39:20 GMT

Hi Mambi Badi,

Please check if this is what you're looking for

Regards,

Re: Dynamic cyclic group

mambi — Thu, 29 Oct 2015 12:24:49 GMT

Hi,

sorry but i need the cyclic group and the graph should be with stacked bars.

Re: Dynamic cyclic group

mambi — Thu, 29 Oct 2015 12:25:35 GMT

the problem isn't with the expression but with cyclic group items list,

i used : TOTAL <Category>... because in the %dimensions list box i can select more than one item at a time

Re: Dynamic cyclic group

miguelbraga — Thu, 29 Oct 2015 12:27:04 GMT

I'll make what you want

Re: Dynamic cyclic group

miguelbraga — Thu, 29 Oct 2015 12:30:23 GMT

Here take a look.

Snapshot:

Re: Dynamic cyclic group

mambi — Thu, 29 Oct 2015 13:17:44 GMT

Sorry, but here what i should get : for exemple if i select category in the %dimensions:

and in this case : the cyclic group shouldn't contain the Category in the list of choices.

Re: Dynamic cyclic group

avinashelite — Thu, 29 Oct 2015 14:16:21 GMT

Check the attachment for the solution

Re: Dynamic cyclic group

mambi — Thu, 29 Oct 2015 14:41:18 GMT

what i want to do is :

- when Country is selected in the listbox the cyclic group should contain only : Product and Category

- when Category is selected in the listbox the cyclic group should contain only : Product and Country

- when Product is selected in the listbox the cyclic group should contain only : Category and Country

- when Country and Category are selected in the listbox then the cyclic group should contain only Product

- when Country and Product are selected in the listbox then the cyclic group should contain only Category

- when Product and Category are selected in the listbox then the cyclic group should contain only Country.

and all this dynamically because the number of items in the listbox can increase over time.

Re: Dynamic cyclic group

ramoncova06 — Thu, 29 Oct 2015 20:46:47 GMT

and what if nothing is selected in the listbox, are you expecting to see all three ?

Re: Dynamic cyclic group

smirkinaa — Fri, 30 Oct 2015 09:44:09 GMT

Hi, it is not beautiful solution, but it is . You may use several cyclic dimensions. Then, show or hide depend on selections in appropriate field.

Re: Dynamic cyclic group

mambi — Fri, 30 Oct 2015 11:07:21 GMT

i use a conditional display : GetSelectedCount(%dimensions)>0