Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
rennesia
Contributor III
Contributor III

How to show a line chart with two dimensions with different expressions?

In a line chart, I want to show the production values for two different periods. What is the best way to realize this?

6 Replies
sunny_talwar

Use if statement in the background color

If(Dim2 = 'XYZ', Yellow(), Blue())

rennesia
Contributor III
Contributor III
Author

The color isn't the problem... How to show the second line with a different timestamp?

sunny_talwar

May be like this as your calculated dimension

Dual(Date & Chr(10) & AddYear(Date, -1), Date)

MarcoWedel

Hi,

front end solution could be:

QlikCommunity_Thread_217880_Pic1.JPG

QlikCommunity_Thread_217880_Pic2.JPG

or

QlikCommunity_Thread_217880_Pic3.JPG

QlikCommunity_Thread_217880_Pic4.JPG

QlikCommunity_Thread_217880_Pic5.JPG

but I would suggest to use the calculated dimension expressions in the script to generate additional fields you could use in the charts instead.

hope this helps

regards

Marco

rennesia
Contributor III
Contributor III
Author

Thanks Marco for your examples. They are helpful for my problem, but not the complete solution. The two dates belong to two different (independent) fields, with a selection for both fields...

A_Timestamp     A_Percentage

18-04-2016          54.6
19-04-2016          76.4

B_Timestamp     B_Percentage
20-05-2016          12.4
21-05-2016          54.3
22-05-2016          65.3                      

rennesia
Contributor III
Contributor III
Author

Thanks for your answer, but my problem is unfortunately more difficult. See below...