topic Re: Expression in QlikView

Expression

Tue, 17 Jun 2014 04:34:35 GMT

Hi All,

Thanks for yours reply . I have a bar chart and i need to have to dimensions placed vertically (Activity and Delivery)

agains one dimension (Campaign ) . So what iam doing is , iam taking campaign as dimension , and under expression iam taking Count(Activity) Count( Delivery) , So this is giving me total count of Activity and Delivery against campaign .

But instead of count i want to to display the content within Activity and Delivery . I Hope iam clear

Thanks in Advance

Re: Bar Chart

amit_saini — Tue, 17 Jun 2014 04:37:40 GMT

Wrestler,

Go to chart properties->Style Tab->and select Subtype as "Grouped" instead of Stacked.

Thanks,
AS

Re: Expression

shawn-qv — Tue, 17 Jun 2014 06:36:40 GMT

Not completely sure what you're asking. Perhaps you can try the Table Box if you just want to list the data and not do any calculation(s).

Re: Expression

Tue, 17 Jun 2014 06:38:46 GMT

Table box.

Re: Expression

its_anandrjs — Tue, 17 Jun 2014 06:39:45 GMT

Elaborate more about the requirement please.

Re: Expression

tresB — Tue, 17 Jun 2014 06:43:33 GMT

Table box

Straight table (with no expression and 'Supress Zero Values' UnChecked in the presentation tab)

Re: Expression

its_anandrjs — Tue, 17 Jun 2014 06:47:34 GMT

You can use any chart like Straight, Pivot and Table box just add all dimensions to the chart for straight and Pivot i am telling and then from Presentation un-check the option Suppress Zero values.