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: 
Aspiring_Developer
Creator III
Creator III

Displaying result on the basis of selection inQS

Hello All, 

I wish to achieve below:-

Created inline table for filters

load *inline[

Dimension

Actual

Budget

Bugdet 2020

];

 

I have to create a filter of the above table and create a data table .

If user select "Actual" it should display the expression of actual (Sum(Sales))

if user select "Buget", then display the expressiom Sum(Amount)

if user select Budget2020, then it should display expression sum (Currency)

 

I tried below

-Created the inline table

-took the dimension

in the expression of the chart , i tried

if(getfieldselection(Dimension)='Actual', Sum(Sales),

if (getfeildselection(Dimension)='Buget, sum(Amount)

else Sum(Currency).

Still not getting the correct result.

Can anyone please help ?

1 Reply
ibdK4evr
Contributor III
Contributor III

Hi, 

Can you pls attach the screenshot of your inline table and what is the result that you are getting now ?