Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi..,
I have one field and two expressions
Then I took a Combo chart in Qlik view
Dimension:
Year_month field contains 2020_01 to 2022_12
Expressions :
Sum(Sales) 1st Expression it contains data from 2021_04 to 2022_04
'Pipeline' &':'& Round(sum(Tprice_Converted)/1000000,0.1) 2nd Expression
Display options for expressions:
1st expressions set as bar
2nd expressions set as text as pop up
and enabling another option 'supress zero values' in presentation tab
Problem:
When enabling 1st expression then dimension Year_month is from 2021_04 to 2022_04
but when enabling 2nd expression the dimension Year_month is from 2021_01 to 2022_12
but I need when enabling 2nd expression then the dimension Year_month is from 2021_04 to 2022_04
Thanks in Advance
Hi
Try like below
'Pipeline' &':'& Round(sum({<Year_month ={"=Sum(Sales)>0"}>}Tprice_Converted)/1000000,0.1)