topic Trends on % values in QlikView

Trends on % values

stevejones1 — Wed, 22 Aug 2018 23:39:23 GMT

Attached is my file , i am trying to create a trend line based on CSAT values , but when i do not select any value , no data is shown in the chart, where as when i select a casenumber i do see the correct percentage value,

Can someone pls help me to show the trend line

Thanks

Re: Trends on % values

Sergey_Shuklin — Thu, 23 Aug 2018 05:58:38 GMT

Hello, Steve!

You are using Only() function on your chart. When more than single value of your expression per period is returned the Only() function will be equal Null().

So, dependind of what you want to calculate you should use a correct function. For instance, if you change Only to Sum you will see values on the chart w/o any selections.

Re: Trends on % values

uroboros — Thu, 23 Aug 2018 06:18:56 GMT

Hi! In fact, it caused because you're using Only(), and when not have selections you have a null() (Null pointer exception - lol); just try the same with a sum(Disticnt <>) it should be resolve you situation.

PD:
Try this:

Sum(DISTINCT{<CaseStatus = {'Closed'},CSATSent ={'true'},CVAFlag ={1},Indicator ={'Closed'}>}[CSAT])