topic Re: Using Getfieldselection need to select multiple values in QlikView

Using Getfieldselection need to select multiple values

VenkateshYarra — Sat, 16 Nov 2024 01:36:21 GMT

HI All,

Wish you a very happy new year to all..🙂

I have two tables, where i need to calculate distinct values of each fields in each table. ( All fields are same in both tables)

So i created one Inline Table using all fields for selection purpose. Below are the Image of Inline Table.

vFields ='[Quotes.'&GetFieldSelections(Inline_Fields)&']'

Then in the expression i am using he below expression to get the results

=SUM(Aggr(Count(DISTINCT $(vFields)),$(vFields)))

Till here it is working fine. If i select it is show the value. But when user select multiple values/Fields in Inline table how to show the values.

I tried the below expression

vFields1 ='[Quotes.'& concat (distinct Inline_Fields,']'&','&'[Quotes.')&']'

But this is not working for me.

Can you any help me to solve this issue.

I need to get multiple values if i select multiple fields in Inline table. Like below image. Here all quote values are showing zero.

Kindly Ignore the Pricing.

Thank you

Regards

Venkatesh

Re: Using Getfieldselection need to select multiple values

lorenzoconforti — Fri, 03 Jan 2020 14:52:22 GMT

This is very tricky as you cannot use the value of a specific dimension as an input to another aggregation; unless you use a series of nested if statements; this is the formula to go in your table to replace the sum/aggr you have in there; also, you don't need extra variables:

=if(Inline_Fields = 'Active Flag',count(distinct [Quotes.Active Flag]),
if(Inline_Fields = 'Approval First Date',count(distinct [Quotes.Approval First Date]),
if(Inline_Fields = 'Approval Last Date',count(distinct [Quotes.Approval Last Date]),
if(Inline_Fields = 'Approval Status',count(distinct [Quotes.Approval Status]),
if(Inline_Fields = 'ID',count(distinct [Quotes.Active Flag]),'ID')
))))

Since the set of dimensions you are calculating the distinct values for is fixed I believe this is a viable solution; you just need to write the nested if statements once and then you are sorted

Re: Using Getfieldselection need to select multiple values

bramkn — Fri, 03 Jan 2020 14:59:39 GMT

A pick(match()) would be a better idea. always try to avoid using nested if statements.(or if statements alltogether in the frontend)

Re: Using Getfieldselection need to select multiple values

VenkateshYarra — Sat, 04 Jan 2020 14:25:09 GMT

Thank you.

If Condition as well as Pick and Match function are working, Both functions are working. I go with Pick and Match function

Thank you again