topic Re: Filter on expression selection in QlikView

Filter on expression selection

SunilChauhan — Tue, 14 Apr 2015 05:40:46 GMT

Hi all,

Hope you doing well!

I have created a chart where i have a dimension Function and expressions below

sum( {<flag={'Y'}>},ID)

sum({<NewFlag='X'>} NewID)

i have raw data where ID,New ID and Flag value Y,N

New flag value X,Y,N

so my requirement is to filter raw data table when i click on particular expression i dont want to write a macro.

also now want to redirect to some URl for displaying filtered data.

Could you please suggest some way to do this.

NOte: Although I know expressions could not be selected.then also hoping a solution here.

Thanks

Sunil Chauhan

MK_QSL — Tue, 14 Apr 2015 06:26:21 GMT

This sum( {<flag={'Y'}>},ID) should be sum( {<flag={'Y'}>}ID) !

You can use conditional Expression for every expression and handle them by variable and assign this variable to a button with action !

SunilChauhan — Tue, 14 Apr 2015 06:30:19 GMT

thanks Manish ,i have written correct expression , is my mistake while writing

i have around 15 expressions .do you thing we could create 15 different button selection?

MK_QSL — Tue, 14 Apr 2015 06:35:36 GMT

If you want to show one or more expression at a time, you can use Customisable Straight Table... Use below link..