topic Line Chart in QlikView

Line Chart

smilingjohn — Wed, 25 Nov 2020 16:16:04 GMT

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 .

Re: Line Chart

Surya — Wed, 25 Sep 2019 06:59:04 GMT

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

Re: Line Chart

smilingjohn — Wed, 25 Sep 2019 08:07:20 GMT

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

Re: Line Chart

Surya — Wed, 25 Sep 2019 09:52:50 GMT

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

Re: Line Chart

Surya — Wed, 25 Sep 2019 09:55:12 GMT

you just try dimension date expression count(seviertry)

Re: Line Chart

raman_rastogi — Wed, 25 Sep 2019 10:04:54 GMT

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

Re: Line Chart

smilingjohn — Wed, 25 Sep 2019 11:04:17 GMT

Hi Raman

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

please find the attachment of the QVW file

Re: Line Chart

raman_rastogi — Wed, 25 Sep 2019 11:51:56 GMT

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,

Re: Line Chart

smilingjohn — Wed, 25 Sep 2019 12:57:38 GMT

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

Re: Line Chart

smilingjohn — Wed, 25 Sep 2019 13:43:12 GMT

Got the solution ,

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