Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

vinay_hg
Contributor II

Need help - table query, based on condition show in table - Qliksense

we know how to do it in Qlik View, ass conditional dimension,

based on the month selection single or multiple, onfly we need to populate the table data.

please help..

for eg in below data if I select month as Jan2016 to feb2016, then I need max month record in jan and feb for project A & B I need

on below data my result should be,

A, Feb2016

B,Feb2016

if nov2015 to dec2015

A, Dec2015

B,Nov2015 (as no dec 2015 data)

month selected may be 2 months or more. max month record shoul appear with remaining column on fly.. please help.

   

ProjectID([Month])DN_TrendDatexStagetotal
ANov 201501-11-15 0:00--0
ADec 201501-12-15 0:00--0
AJan 201601-01-16 0:000013
AFeb 201601-02-16 0:000113
AMar 201601-03-16 0:000114
AApr 201601-04-16 0:000114
AMay 201601-05-16 0:000214
BDec 201501-12-15 0:00--0
BJan 201601-01-16 0:00-00
BFeb 201601-02-16 0:00010
BMar 201601-03-16 0:00010
BApr 201601-04-16 0:00010
BMay 201601-05-16 0:00010
BJun 201601-06-16 0:00010
BJul 201601-07-16 0:00010
BJan 201701-01-17 0:00010
BFeb 201701-02-17 0:00010
BMar 201701-03-17 0:00010
Tags (1)
1 Reply
vinay_hg
Contributor II

Re: Need help - table query, based on condition show in table - Qliksense

need help..

Community Browser