Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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