Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
HKN1
Contributor III
Contributor III

Line Chart with value list

Hello,

I want to show the X value on the line graph starting from 0. Can you help me please?

 

Thanks

 

HKN1_0-1697723230651.png

 

 

HKN1_1-1697723248144.png

 

 

Labels (1)
3 Replies
maheshkuttappa
Creator II
Creator II

Try this  

First Measure :If(ValueList(1,2)=1,0, Sum({<Department={'A'}>}Sales))  

2 measure: If(ValueList(1,2)=1,0,Sum({<Department={'B'}>}Sales))

Dim: =ValueList(1,2) (hide x axis label)

mahesh3k_0-1697744862342.png

 

 

HKN1
Contributor III
Contributor III
Author

Hello,

You wrote <Department={'A'} and <Department={'B'}

I'm sorry but I don't understand 😞

For example, where is the error below?

 

Thanks.

 

 

Dimesion:

=ValueList('Daily', 'for 15 days', 'Monthly', 'Yearly')

 

Expression:

If(ValueList('Daily', 'for 15 days', 'Monthly', 'Yearly') ='Daily',0,
Count({<Year = {"$(=Date(Today() -1,'YYYYMMDD'))"}>} tav)

 

 

HKN1_0-1697807074862.png

 

 

....

HKN1
Contributor III
Contributor III
Author

I guess it will be 🙂

 

All values need to start at 0

 

 

HKN1_0-1697808957453.png