In SET even i select year=2016 , it can display sales for year = 2015. How above can i force table display SOURCE=TDSKL , WHEN USER SELECT SOURCE=TDSS ?

[paulyeo11]

Hi All

I have below expression work fine :-

=if(Match(SOURCE,

'TDSID',

'G2-AP')

, SOURCE)

Above expression will list SOURCE = TDSID , When SOURCE Is not select.

Now my issue is when user select SOURCE - TDSKL , IT There any way i can force the table display SOURCE=TDSID

mY Objective is to use this for qlik sense , as QS don't have button action.

Paul

[#2]

Hi @Paul,

My understanding is you want to use Qliksense. Since there is no default button Extension in Qliksense unlike Qlikview, you wanted to add button or event that would trigger to select an item?

If this scenario is correct, you could use this extension >> GitHub - stefanwalther/sense-navigation: Sheet Navigation + Actions for Qlik Sense..

You can add buttons extensions and actions using that. I hope this is the solution that you wanted.

Marvs

[PrashantSangle]

Hi,

I am busy with another work.

just saw your file Since set analysis is case sensitive

in your expression write SOURCE instead of source. then it will work fine.

Regards

[MK_QSL · Accepted solution]

Create a Table

Dimension

COMPANY

SOURCE

Expression

IF(GetSelectedCount(SOURCE), SUM({<SOURCE+={'TDSID','G2-AP'}>}(days3 + days6 + days9 + curren)),

SUM({<SOURCE={'TDSID','G2-AP'}>}(days3 + days6 + days9 + curren)))

[paulyeo11]

Hi Manish

I like to said a big thank to you .  your expression help me a lot to make my table now it work fine.

Below expression work fine :-

=if(Match(SOURCE,

'TDSID',

'G2-AP')

, SOURCE)

Above expression will list SOURCE = TDSID , When SOURCE Is not select.

Now my issue is when user select SOURCE - TDSKL , IT There any way i can force the table display SOURCE=TDSID

Paul

[paulyeo11]

hI mARVIN

Thank you very much for introduce me new extension.

it is very user friendly , i just try and it work.

I think i will try to this soon

Paul

[paulyeo11]

Hi Max

Thank you for your help , now my table work fine.

Paul

[paulyeo11]

‌Hi manish

Can you send me a email paulyeo@tdstech.com

Paul