Combo Chart

[Saiteja1]

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

[MayilVahanan]

Hi

Try like below

'Pipeline' &':'& Round(sum({<Year_month ={"=Sum(Sales)>0"}>}Tprice_Converted)/1000000,0.1)