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

How to write the expression

I got a chart like below :

Capture.PNG

By default , I don't want to show Precessed . so thus , I used the expression fo 'Sales Value'

sum({$<TranType = {$(vAmountType)},[Fiscal_Year]=,[Month]=,category_of_sales={'*'}-{'Processed'}>} Amount) Capture.PNG

Then getting the above chart, which is my requirement.

But , when I am trying to select 'Unprocessed' and 'Unspecified' then it is not selecting.

How can I select 'Unprocessed' and 'Unspecified' ?

1 Solution

Accepted Solutions
Peter_Cammaert
Partner - Champion III
Partner - Champion III

With this?

sum({$<TranType = {$(vAmountType)},[Fiscal_Year]=,[Month]=,category_of_sales -= {'Processed'}>} Amount)

View solution in original post

3 Replies
Peter_Cammaert
Partner - Champion III
Partner - Champion III

With this?

sum({$<TranType = {$(vAmountType)},[Fiscal_Year]=,[Month]=,category_of_sales -= {'Processed'}>} Amount)

Kushal_Chawda

would you be able to share the sample?

Anonymous
Not applicable

Just Click on 'Unprocessed'...see whether selection is happening.

Also make it fully compressed either by clicking on + sign or

Properties - > Presentation - > Always Fully Compressed(Left Bottom)