topic Re: How to create chart using SET analysis in QlikView

How to create chart using SET analysis

Sun, 26 Jan 2014 13:38:04 GMT

Hi,

I have a columns in my table as follows (with some sample data):

Date Hour Price

20/01/2014 18:00 5:00

20/01/2014 19:00 10:00

20/01/2014 20:00 15:00

22/01/2014 18:00 5.00

22/01/2014 19:00 20.00

22/01/2014 20:00 10.00

23/01/2014 18:00 8.00

23/01/2014 19:00 8.00

23/01/2014 20:00 8.00

....

I would like to plot a chart of all individual price (y axis) over hours (y-axis) for a certain date (say 22/01/2014). Please can you give some advise how this can be accomplished, presumably using SET analysis.

Thanks

Shaun

Re: How to create chart using SET analysis

Gysbert_Wassenaar — Sun, 26 Jan 2014 14:42:24 GMT

The easiest way is to use a listbox to simply select the date. That way you don't need set analysis at all. If you want to hardcode the date then you can use the expression only({<Date={'22/01/2014'}>} Price).

Re: How to create chart using SET analysis

Sun, 26 Jan 2014 17:10:18 GMT

Thanks, the only functions worked with the set analysis.