Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
scotly-victor
Creator II
Creator II

How can I get Table column value and use it in Measure

Hi,

How can I get Table column value and use it in Measure


Please find Image for reference

9 Replies
Anonymous
Not applicable

Hi,

You can only set one value at a time to right hand-side of set analysis. You cannot go further than [SUB CATEGORY] = {$(vGroup1)} .

Let us know what would you like to achieve exactly so maybe we can try to find a workaround.

Best Regards

Serhan

Oleg_Troyansky
Partner Ambassador/MVP
Partner Ambassador/MVP

Please keep in mind that Set Analysis cannot be sensitive to the values of a chart Dimension, because Set Analysis conditions are being applied before the chart is calculated.

However, the sum() in a chart will already calculate the measure for the values of your dimensions. You don't need to add this condition again. Or, are you trying to calculate a total by Category? Then, use the prefix TOTAL, like this:

sum(TOTAL <Category> Value)

when Category is one of your chart dimensions.

cheers,

Oleg Troyansky

Learn advanced QlikView and Qlik Sense techniques in my book QlikView Your Business

scotly-victor
Creator II
Creator II
Author

What actually need is

I want use corresponding column value in my set analysis in Straight  Table

column 1  column 2(measure)

banana   sum({fruit={'banana'}}sales)

apple    sum({fruit={'apple'}}sales)

likewise I should get the output

Is there any function there to achieve this.

shraddha_g
Partner - Master III
Partner - Master III

If your column 1 is Fruit ,then you don't need set analysis as sum({<fruit={'apple'}>}sales). Sum(Sales) will work.

scotly-victor
Creator II
Creator II
Author

Column1 works on GetFieldSelections

selected value should be shown in column1

shraddha_g
Partner - Master III
Partner - Master III

can you share the sample app?

tresesco
MVP
MVP

So if nothing is selected in Fruit field, it should not show all fruits unlike in normal sum(Sales) expression, right?. If so, you could just put an additional check like:  if(GetSelectedCount(Fruit), Sum(Sales))

Anonymous
Not applicable

Hi,

Simply =sum(sales) should work then, shouldn't it????

column 1  column 2(measure)

banana   sum(sales)

apple    sum(sales)

Assuming your table structure is correct!!!

Best Regards

Serhan

imrencimen
Contributor III
Contributor III

İf TOTAL function is insufficient try AGGR function.

Sum(Aggr(([BILL ID]),[SUB CATEGORY]))