topic Re: How to made actions in QlikView

How to made actions

Thu, 30 Jun 2016 14:52:56 GMT

Hi Guys,

I have table with fileds

YTD

MTD

WTD

PTD

LYTD

LMTD

LWTD

LPTD

My Requirment is

If i clik on YTD i want to display YTD,LYTD values in a comparision manner.

If i clik on MTD i want to display MTD,LMTD values in a comparision manner.

If i clik on WTD i want to display WTD,LWTD values in a comparision manner.

If i clik on PTD i want to display PTD,LPTD values in a comparision manner.

Thanks

Siva Reddy

Re: How to made actions

johnw — Thu, 30 Jun 2016 15:45:05 GMT

If your field is [Period], then you could create a field [Period Group] that includes the two periods you want to see for each period group. Select the period group. Use period as the chart dimension.

[Period Groups]:
LOAD
[Period Group]
,subfield([Periods],',') as [Period]
INLINE [
Period Group:Periods
YTD:YTD,LYTD
MTD:MTD,LMTD
WTD:WTD,LWTD
PTD:PTD,LPTD
] (delimiter is ':');