topic Re: Requirement on If condition in QlikView

Requirement on If condition

chinnu123 — Wed, 25 Nov 2020 16:16:04 GMT

Hi Team,

I have a requirement to display four quarters in four objects(straight tables).

I.e we have four quarters named Q1, Q2,Q3,Q4

In the first table q1 data must display second table q2 third table q3....

Here the condition is I have a field name called Country And the values are USA, CANADA,INDIA etc

Here I need to write a condition related to country and quarter

I.e if we select country usa the usa q1 data must be dispalyed in first table

if we select country usa the usa q2 data must be dispalyed in second table.

In the same way for other countries

Can any one give the synatax for this

Thanks in Advance

Chinnu

Re: Requirement on If condition

swuehl — Sat, 11 Jun 2016 18:59:34 GMT

If you make active selections in Country field, e.g. 'USA', your chart automatically will reflect this selection (Qlik logic default behaviour).

To filter quarters, you can use either an if() statement or set analysis in your chart aggregation functions:

=Sum( If(QuarterField = 'Q1', Amount))

=Sum({<QuarterField = {'Q1'}>} Amount)

Accordingly for other quarters.

Re: Requirement on If condition

trdandamudi — Sat, 11 Jun 2016 19:06:49 GMT

May be as attached... Please modify according to your needs:

Re: Requirement on If condition

chinnu123 — Sat, 11 Jun 2016 19:11:25 GMT

Thanks for the reply swuehl,

Here the Country is selection field (multi box) for the Users. Users will select country in which they need to see the quarter results so they can select any of the country

Re: Requirement on If condition

trdandamudi — Sat, 11 Jun 2016 19:15:23 GMT

That is what Stefan is saying "Qlik logic default behaviour". When you select different countries from the list box it will show you the selected countries in your table/chart.

Hope this helps...