topic Alternate state with chart dimension in QlikView

Alternate state with chart dimension

Sat, 15 Nov 2014 07:02:44 GMT

Hi friends,

I want to show comparative analysis in pivot table where I have to show the selected dimension value for each alternate state group.

I dont know whether it is possible or not,but if anyone has any idea or suggestion please share with me.please find attachment for a sample application

Re: Alternate state with chart dimension

morgankejerhag — Sat, 15 Nov 2014 09:57:33 GMT

Hello,

Maybe you can set the label to:

=concat({State1} distinct Client,',')

This will contatenate all possible values from field Client. See attached file.

Best regards,

Morgan Kejerhag

Senior Business Intelligence Consultant, Drake Analytics

http://www.drakeanalytics.se

Re: Alternate state with chart dimension

Sat, 15 Nov 2014 10:54:41 GMT

Hi,

Do you mean like this:

label your expression as:

=Concat({[State1]} DISTINCT Client, ', ') & ' Sales'

same for the 2nd expression but with [State2].

You can select more than 1 client, they'll be separated by commas.

Is that what you want ?

Re: Alternate state with chart dimension

Sat, 15 Nov 2014 11:27:02 GMT

I already used this option and this is only a sample but in the main application there are number of client and then this option is not feasible there.. is there any other way to do

Re: Alternate state with chart dimension

morgankejerhag — Sat, 15 Nov 2014 11:37:31 GMT

What do you mean by "there are number of client"?

Best regards,

Morgan Kejerhag

Senior Business Intelligence Consultant, Drake Analytics

http://www.drakeanalytics.se

Re: Alternate state with chart dimension

Sat, 15 Nov 2014 11:39:56 GMT

Maybe like this:

=if(Count({[State1]} DISTINCT Client) > 1, 'State1 Sales',

Only({[State1]} Client) & ' Sales'

)

When more than 1 possible client => State sales

otherwise specific client.