topic Re: Button with Select in Water Cooler

Button with Select

Mon, 14 Apr 2014 03:10:35 GMT

Hi All,

I have a question about this:

two tables

one call master:

[Master]:

LOAD * INLINE [

MemberCode, Name

1234, SA

2345, TA

3456, NA

];

other detail:

[Detail]:

LOAD * INLINE [

MemberCode, type, Amount

1234, R, 23

1234, S, 234

2345, R, 23

3456, S, 23

];

I want to create 3 button based on type ('R','S','R&S'):

Data show like below:

MemberCode,Name,Btype

1234,SA,R&S

2345,TA,S

Is there any way to do this.

Thank you very much

Re: Button with Select

whiteline — Mon, 14 Apr 2014 05:48:38 GMT

HI.

To show the data like above, create chart:

dimensions: MemberCode, Name

expression Btype: =concat(type,'&')

Re: Button with Select

sujeetsingh — Mon, 14 Apr 2014 05:56:16 GMT

See this

Re: Button with Select

Mon, 14 Apr 2014 06:55:52 GMT

hi,

Sorry,i can't open the file.

Screenshot it?

Thank you very much!

Re: Button with Select

Mon, 14 Apr 2014 06:56:36 GMT

Hi,

how to ceate button?

thank you very much!

Re: Button with Select

ngulliver — Mon, 14 Apr 2014 08:03:44 GMT

Hi, Harry.

Have a look at Steve's blog on buttons. There are some working examples you can use:

http://www.quickintelligence.co.uk/qlikview-buttons/

Cheers,

Neil