Conditional data in Qliksense straight table

[dhavalvyas]

Hi,

I have requirement to show conditional data in Qliksense table.

Straight table should show data for Quarterly only if Quarter gets completed, else it should show data on monthly basis.

For eg: Currently July month is going on.

1> My straight table should show 3 columns Q1,Q2 and July.

2> In next month It should show 4 Columns Q1,Q2,July and August.

3> In Next to next month it should show 5 Columns Q1,Q2,July,August and September.

4> Once October started it should show 4 Columns,Q1,Q2,Q3 and October

[edwin]

you should have a condition expressions to show the 3rd quarter, 2nd and 3rd months

create 6 measures for the 3 quarterly and 3 monthly, add the condition in the SHOW COLUMN IF fo rthe 3rd quarter, 2nd and 3rd months

hope that helps you solve your problem

[brunobertels]

Hi 

I assume you have a master calendar with date week  month quarter etc 

I So 

add column for Quarter , one for each : 

Q1

Q2 

Q3

Q4 

add 12 column for months one for each call them jan feb mar etc 

use as mesure set analysis 

for example Q1 somethink like : sum({<Quarter={'Q1'}>}Sales)

repeat and adapt the mesure for each column 

after in all column add a conditionnal mesure to show / hide 

eg : for quarter column Q1

if(max({<Quarter={'Q1'}>}DATE_JOUR) < today(),'1','0')

Q2 : 

if(max({<Quarter={'Q2'}>}DATE_JOUR) < today(),'1','0') and so on .. 

for month column : 

if(max({<Month={'jan'}>}DATE) < today(),'1','0') and so on 

Regards