Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
smilingjohn
Specialist
Specialist

Line Chart

Hi All,
I am trying to get a line charts ,
for daily dates by severity .

after implementing the chart i just get one single line with different colors for all the severity
I have four Severity and my requirement is to show all the 4 lines in the chart how do i get this .

Please find the sample data attached .

1 Solution

Accepted Solutions
smilingjohn
Specialist
Specialist
Author

Got the solution , 

Actually i have to convert  the  date format  like date(floor(date),'DDMMYY')as Date and this resoved the issue 

 

View solution in original post

9 Replies
Surya
Creator II
Creator II

Right ow you are taken dimension date and severity remove dimension date u got output

smilingjohn
Specialist
Specialist
Author

Hi Surya ,

This is the sample data i have shared with only two fields , in real i have many fields and i need to show the line chart 

using date and severity . 

If i remove the date then it will show by severity for all the keys, 

but my requirement is to show it by date and severity  . 

Thanks in advance 

Surya
Creator II
Creator II

Your requirement is not clear., every day having one one value...so as per your provided data its working fine for ex today date taken 1 ..expression u return count(today) that s also 1 so thats y u got single line
Surya
Creator II
Creator II

you just try dimension date expression count(seviertry)
raman_rastogi
Partner - Creator III
Partner - Creator III


Hello,

For four different lines based on severity you need to create four expressions.

Something like this

Dim- Date

Exp

1-count({<Severity ={'Severity 1'} > }Dailydate)

2-Exp1- count({<Severity ={'Severity 2'} > }Dailydate)

3-........

 

Regards

Raman 

 

smilingjohn
Specialist
Specialist
Author

Hi Raman

Thanks for the reply , I used four expression but still i see single line ..

please find the attachment of the QVW file 

raman_rastogi
Partner - Creator III
Partner - Creator III

Hi,

it is creating one single line because values of all expressions are same , all lines are overlapping .

Once try with actual data if issue still persist use different chart like stack bar chart.

Thanks,

 

smilingjohn
Specialist
Specialist
Author

I converted it to a bar chart , please look into the attachment in which for severity 3 it is showing three times for 23 Sep 2019

it show 3 counts right ?  why is not the date showing one time , why is it repeating for all the severity . 

 

I am really confused 

smilingjohn
Specialist
Specialist
Author

Got the solution , 

Actually i have to convert  the  date format  like date(floor(date),'DDMMYY')as Date and this resoved the issue