topic Legend wrong in QlikView

Legend wrong

0li5a3a — Tue, 08 Aug 2017 13:19:34 GMT

hI all.

I need to display in a Bar Cart the total number of the tickets for the last 30 days.I have a field named Severity where I have something like this Severity = S1, S2, S3, S4, S5,etc.

I want to display only the data for the last 30 days for a specific customer and I want to display the days without tickets too.

like below.

Dimensions :

Day

and

= IF( Customer LIKE 'xxx', Severity)

Expressions:

count({< Date = {"<=$(=DATE(MAX(Date)))>=$(=DATE(MAX(Date)-30))"}>}TICKETID)

and

sum(1) I use this to display all the dates with no data so this is blank.

I the below chart the data is selected ok only the problem is with the legend because I can see all the Severities, there suppose to be just the severities for the last 30 days but in may example are all for example S1 which is from 2 months ago.

Could someone please advise ?

Re: Legend wrong

Anil_Babu_Samineni — Tue, 08 Aug 2017 13:24:18 GMT

May be try this for Dimension

= IF( Match(Customer, 'xxx'), Severity)

OR Using Set analysis

count({< Date = {">=$(=DATE(MAX(Date)-30)) <=$(=DATE(MAX(Date)))"}, Customer = {xxx}>}TICKETID)

Re: Legend wrong

0li5a3a — Tue, 08 Aug 2017 13:31:20 GMT

Hi Anil, I tried but this doesn't works in my case:(. Thanks

Re: Legend wrong

Anil_Babu_Samineni — Tue, 08 Aug 2017 13:54:32 GMT

This, Doesn't for you?

count({< Date = {">=$(=DATE(MAX(Date-30))) <=$(=DATE(MAX(Date)))"}>}TICKETID)

Re: Legend wrong

0li5a3a — Tue, 08 Aug 2017 14:01:15 GMT

I tried to add it to the expression and no results. I think , I need to restrict the dimension in some way... for the last 30 day... and maybe this would works. The problem when I restrict the data for the last 30 days I loose all the days with no data.

Re: Legend wrong

Anil_Babu_Samineni — Tue, 08 Aug 2017 14:05:32 GMT

Usually, I don't prefer to use calculated dimension , Any way

Can you show image where you did?

Re: Legend wrong

0li5a3a — Tue, 08 Aug 2017 14:09:40 GMT

Re: Legend wrong

0li5a3a — Tue, 08 Aug 2017 14:12:42 GMT

Re: Legend wrong

0li5a3a — Tue, 08 Aug 2017 14:16:44 GMT

and here I changed the dimension day to be op_date and I enable the second expression which was SUM(1) to display the null.

After I do all the above I can see that the legend now shows right but I need to see the dates with don't contains any tickets

Re: Legend wrong

Anil_Babu_Samineni — Tue, 08 Aug 2017 14:18:00 GMT

This won't help to me. Will you provide sample? Instead xxx you could use your Value

Re: Legend wrong

0li5a3a — Tue, 08 Aug 2017 14:47:46 GMT

I made some test data please check the above attached files.

Re: Legend wrong

Anil_Babu_Samineni — Tue, 08 Aug 2017 15:15:26 GMT

How come you say, This is not working. Even though.. you don't have more than 30 Dates in your Model. Does it make sense?

Re: Legend wrong

Anil_Babu_Samineni — Tue, 08 Aug 2017 15:15:57 GMT

Re: Legend wrong

0li5a3a — Tue, 08 Aug 2017 15:28:16 GMT

Please check now the new attached files. I just amend them.,

Re: Legend wrong

0li5a3a — Tue, 08 Aug 2017 15:28:49 GMT

please check the new files. the first one they are not the best version.

Re: Legend wrong

Anil_Babu_Samineni — Tue, 08 Aug 2017 15:50:11 GMT

Check this?

Re: Legend wrong

0li5a3a — Tue, 08 Aug 2017 20:17:20 GMT

Well done Anil! Many Thanks!

Re: Legend wrong

0li5a3a — Tue, 08 Aug 2017 20:29:20 GMT

Hi Anil, I have checked now and if for example in the excel files for the Customer 'ABC' we don't have any severity the date 29/07/2017 is not displayed.

I attached again the excel files where I made the the above changes.

Could you please advise ? That was the reason why I used the sum/(1) to be blank, to display the missing dates. But if I do this I would have more data into the legend and this is not right.

Thanks in advance !

Re: Legend wrong

Anil_Babu_Samineni — Wed, 09 Aug 2017 02:44:52 GMT

Without testing, I am saying this part like even if you don't have dates foe specific customer that's not a big deal. This will exclude and club the previous one if selection happen

Assume, You have date 1-31. For ABC customer you don't have data for 29th then it excludes and it shows as 1-31 without 29th. That qlik can handle.

Make sense?

Re: Legend wrong

0li5a3a — Wed, 09 Aug 2017 08:56:31 GMT

I understand your point of view but for a best practice is good to display the missing dates too and the legend to display only the Severities for the last 30 days.