This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
Hi experts!Hope you have the answer for my question for QlikView a Chart.
Background: I Need a chart with three graphs, each combining a group of customers. The grouping should be dynamic.
My solution was to create three variables, vGroupSel1, vGroupSel2 and vGroupSel3.
In order to set the variables I use three buttons. I select multiple names of a field called GroupSel.Then I press button1 which puts the selected names into the variable vGroupSel1, etc.
Currently I do that with following Button-Action :
=chr(39)&GetFieldSelections(GroupSel,chr(39)&','&chr(39))&chr(39) // CHR(39) fügt ein Aposthroph ein // CHR(39) = '
This works perfect as long as I have less then 6 customers selected. The variable then shows following content:vGroupSel1 = 'Customer A', 'Customer B', 'Customer C'The chart is working fine, too.
But as soon as I select more than 6 field names, what happens is, the variable content changes to:
vGroupSel1 = '7 of 20'
...with the concequence that the chart is no longer working. Of course, the field Name "7 of 20" is no valid field name.
Does anybody know how to change the behavior of QV to rather show all names selected instead of '7 of 20' or '9 of 20' etc?
Or is there any other smart way of creating flexible Graphs as described above?
Thanks in advance!!
Instead of using this
Try this in your buttons
=Concat(DISTINCT chr(39)&GroupSel&chr(39), ', ')
View solution in original post
Thanks, Alex!! That's it. Would you mind to shortly explain why this works ?
Thanks a lot,