topic Designing Challenges in QlikView

Designing Challenges

Wed, 22 Apr 2015 03:40:21 GMT

Hi All,

Q1-

I am looking to display a text when cursor point to a value. I have created a Cyclic Group which consist of 4 fields Country-->State--> City-->Area

So when my Cyclic group is displaying Cities and when my mouse cursor points to a particular city like Richmond then It should display text message like Australia-->Vic-->Melbourne-->Richmond

Q2-

When my Cyclic group is displaying areas and when Select a particular area like Richmond then Field Selection boxes should highlight the values Australia, Vic, Melbourne in Green Color.

So basically I have 4 List boxes for County, State, City, Area so that I can select values from these to filter out data.

I have a graph which displays no employees working under these areas. I found that Richmond is a area where max no employees are working so when I click on Area Richmond then value Australia in List box Country, value Vic in List box State, value Melbourne in List box City should be highlighted in any color like green.

How to achieve either of these or both of these?

Re: Designing Challenges

jagan — Wed, 22 Apr 2015 04:23:53 GMT

Hi,

Attach some sample file and you will get the response quickly.

Regards,

jagan.

Re: Designing Challenges

danieloberbilli — Wed, 22 Apr 2015 04:33:51 GMT

Please find attached.

Q1: if you use a bar chart you could add an expression as text pop-up (and no bars) and insert something like

only(Country) &' -->'& Only(City) &' -->'& Only(Region)

or you script a new field with additional/detailed info and just write only(DetailText)

Q2: Green color in Listboxes indicates an explicit user selection. White color shows the possible values due to a selection status. I would not recommend to change this as this will rather confuse the user (at a later stage) when its not obvious for him/her what is selected and how the data interacts due to the model.

Instead of forcing green color in listboxes I woul rather show an additional textbox with the current possible values (in green)...see example in app

Re: Designing Challenges

danieloberbilli — Wed, 22 Apr 2015 04:36:14 GMT

my example of Q1 would need some finetuning when using in a cyclic group to avoid empty strings

Re: Designing Challenges

Wed, 22 Apr 2015 11:08:37 GMT

Hi Daniel,

Thanks for your solution. It is working for 1-1 mapping between fields.

I used below expression and even this is giving same result.

=IF(GetCurrentField([Region Groups])='State',([Country]&'->'&[State]),

IF(GetCurrentField([Region Groups])='City',([Country]&'->'&[State]&'->'&[City]),

IF(GetCurrentField([Region Groups])='Region',([Country]&'->'&[State]&'->'&[City]&'->'&[Region]),

'')))

But I add another column (Employee Name) to this group and add condition in expression then I am net getting desired result. For Example: One employee (Shivendoo) is working in 2 regions Richmond and Flinders.

When I point my cursor to employee Shivendoo, it should display Australia-->Vic-->Melbourne-->Richmond, Flinders-->Shivendoo

=IF(GetCurrentField([Region Groups])='State',([Country]&'->'&[State]),

IF(GetCurrentField([Region Groups])='City',([Country]&'->'&[State]&'->'&[City]),

IF(GetCurrentField([Region Groups])='Region',([Country]&'->'&[State]&'->'&[City]&'->'&[Region]),

IF(GetCurrentField([Region Groups])='Employee Name',([Country]&'->'&[State]&'->'&[City]&'->'&[Region]&'->'&[Employee Name]),

'')))

Need your suggestion on above expression to display value like Australia-->Vic-->Melbourne-->Richmond, Flinders-->Shivendoo

Re: Designing Challenges

danieloberbilli — Thu, 23 Apr 2015 02:00:15 GMT

This should work with the 'concat' expression (lists all the possible values with a user defined seperator:

...IF(GetCurrentField([Region Groups])='Employee Name',([Country]&'->'&[State]&'->'&[City]&'->'& concat([Region],', ')&'->'&[Employee Name]) ...

Re: Designing Challenges

jagan — Thu, 23 Apr 2015 02:24:24 GMT

Hi,

If you have duplicate values then you can use Concat() function

Concat(DISTINCT Region, ',')

Hope this helps you.

Regards,

Jagan.

Re: Designing Challenges

jagan — Thu, 23 Apr 2015 02:24:55 GMT

Hi,

If you have duplicate values then you can use Concat function

Concat(DISTINCT Region, ',')

Hope this helps you.

Regards,

Jagan.