Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Qlikview experts,
I have set of data several days worth of data with millions of records that have time stamps (e.g. every minute of 5 minute intervals) and several columns containing various information.
To simplify, the columns of interest are:
Time Stamp, User Name, network id, user status, region, throughput
Network status value is either IN or OUT
I am trying to create a chart showing number of distinct users accessing the network over the time (e.g. on hourly basis) or with variable interval and plotting upper and lower bound limit (w/ 95% confidence interval). In this case user status will need to be IN.
What I did was
Dimension = Hour (Time Stamp)
Expression is
count({<[user_status]={'*IN*'}>}distinct([User Name]))
While I can simply show the above expression in the chart, the lower and upper limit w/95% confidence is not properly shown.
Any suggestion how this should be done. Is there any aggregation function that should to be used here?
If I wanted to do the same thing for throughput (e.g. using sum(throughput)), will it be the same expression to be used?
Showing
Also I'd like to be able to show the same thing when changing the dimension to a calculated dimension like below
Timestamp((Ceil([Time Stamp],1/IntervalSize)),'DD-MMM-hh:mm')
The interval size for various period (15 min, 30 min , 1 hour, etc.) is predefined in the loading script.
Well, this is not exactly what I wanted. I wanted to have another symbol
chart along with the line chart. The symbol colors will show different
color if the values exceed ULC or LCL limits.
Is this what you want?
The problem is, when you don't have anything selected, it seems that everything is colored
Thanks, I was able to recreate both after applying the expression for the
background color. The only remaining issue now is the second chart that is
supposed to be a symbol chart remains as line chart instead of symbol
chart, even when I changed the symbol size.
>
I think I know what happened, it seems when all dates were selected the symbols occupied the whole lines and that's proabaly the eason they did not show up. When selected certain day the symbols showed up in the chart.
I think this thread can be closed. Again, many thanks to you!
No problem at all
I am glad we were able to resolve the issue to your satisfaction.
Best,
Sunny