topic Select Field Values from Fields in QlikView

Select Field Values from Fields

shannoypaul — Wed, 06 May 2015 10:34:29 GMT

I have a field 'Frequency' which has 4 values Daily, Weekly, Monthly, Yearly.

I have to Create Charts for all the frequencies separately.

Please let me know how can I use a single field value as the Dimension in the Bar Chart.

Now I when I am using the Bar Chart, all the data with respect to all the frequencies.

TIA,

Re: Select Field Values from Fields

Wed, 06 May 2015 10:38:50 GMT

Hi Shannoy, an example application with a bit more detail would be good to help with this

Re: Select Field Values from Fields

Anonymous — Wed, 06 May 2015 10:40:11 GMT

Hi,

You can do so using set analysis. Suppose you want to create a chart that shows weekly sales, write an expression as sum({<Frequency = {'Weekly'}>}sales)

Regards,

Greeshma